How to delete excel lines that contains

Hello. Could anyone please help me to delete or hide excel lines with condition that certain cells contains “-” symbol? Excel file

ZHR_0065_4_2-135848.XLS (219 KB)

Hi there,

Seems like there are no merged cells or anything, you can use the following options.

  1. If you are good with Macros then you can execute macro deleting or hiding the rows however you want.
  2. Read the range and use filter data table activity and write range again with the new data.
  3. Also you can use ‘Filter table’ activity directly on excel file too.

Tell me whether this works for you :slight_smile: