Find/Replace Excel activity

Hi,

I want to use this activity to find empty cells in a range on an excel sheet and put another value in it.
I know how to use the activity, but don’t know what to put in the field ‘Value To Find’ to detect empty cells. I tried “”, but this will not work, neither leaving the field empty. Any suggestions?
I can read the range to a datatable, replace the ‘empties’ with linq and write back to excel, but I want to avoid this. I prefer to work straight in excel and want to solve the initial wow.
image

@TALLIEU_Johan
U can use

String.Empty

Thanks
VP

Hi @TALLIEU_Johan ,

Can you use Nothing instead of “”

Thanks

UiPath translates this as “”, so same issue persists

With Nothing, UIPatch searches for null, but no sucsess
image

The error I get does not say a lot:
image

Under the “Find What” field, leave it blank to find all blank cells.

So you need to delete the “” and leave that field completely empty!!!

That does not work apparently

image

did you try this " " ?

if not give a try

Regards

Yes, I tried this. It don’t works because the cells are empty and containing no space.