Find and Replace Empty cell with NA or 0 in multiple columns

[Anil_G (Anil Gorthi)]

@ManjuNarasappa

In the value field try Type.Missing ..that should replace the empty cells

The above should work..if not in below thread you can find a macro

I want to put filter for empty cells in this excel and copy the L1 cell value and paste it in rest of the empty cells in L column

@Gopi_Krishna1 you can use read cell to read the data from L1 then use find/replace activity and give Type.Missing in value to find and replace all with value returned from L1 cheers

Cheers