How do I remove a space infront of text in a cell?
Try
=CLEAN(A1)
"GAC" wrote:
I have an Excel sheet that was created from a text file. It has a space in
each cell before the text. I have tried using the Trim function and it is
not removing the extra space. How can I remove the space without doing it
manually?
|