How to delete excel lines that contains

Help
,
1

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

scr1
scr1901×706 27.2 KB
ZHR_0065_4_2-135848.XLS (219 KB)

2

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:

Regards