Find/replace Value: I want to find empty cellls in a excel file and replace with 0

Help Activities
, ,
3

as you are lookin for “” Empty string it will not catch a space
The provided Excel contains space on the cellls which are looking blank

it is risky but you can try

  • first run - replace " " with “”
  • second run - replace “” with 0

When doing this on Datatable level, then you would have a better control on it, as you can use the trim method and would not harm spaces within texts