Hi Experts,

How can i remove/replace all empty text/space in all the cell in a sheet? There's no visible data on the cell but when i use =COUNTA to check - it results into a number which proves that there are empty spaces/text in the cell.

Need the macro to only remove empty text/space on empty cells and not spaces on real values. I can use REPLACE but it also removes spaces from cells with true values.

Please help.