Filter column for empty fields in Excel

Help Studio
, , , ,
1

Hi guys!
I have an Excel file which has data in the column “H” and some cells have data and some don’t. How can my roboter filter column H for cells which are empty? I need to put other data in them (in this case the word worthless). The first row (H1) has to stay untouched. Only the rows from H2 until the last one have to be changed. Is it possible to make an if-condition for that? Like: If column H has empty rows then put Any ideas?

Kind regards :blush:

2

Hi @felixrand

U can use filter datatable activitiy to filter the datatable based in empty values

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

3

@NIVED_NAMBIAR Thanks for replying

Yes I saw it but it doesn’t have the function to replace the empty fields in the column. That’s why I wonder how that can be done