S
Shilpi
Hi!
I have a data which were having the leading spaces in them.I removed the
leading spaces using the following formula
=replace(A2,1,find(LEFT(TRIM(A2),2),A2)-1,"")
It worked and my leading spaces are removed....then i pasted it like a value.
Now the problem is that when i am doing F5>Special>blanks then the blank
cells are not highlighting as a blank.
i want to actually delete the blank cells across the rows
Please help me
Thanks in Advance
I have a data which were having the leading spaces in them.I removed the
leading spaces using the following formula
=replace(A2,1,find(LEFT(TRIM(A2),2),A2)-1,"")
It worked and my leading spaces are removed....then i pasted it like a value.
Now the problem is that when i am doing F5>Special>blanks then the blank
cells are not highlighting as a blank.
i want to actually delete the blank cells across the rows
Please help me
Thanks in Advance