It is, quite possibly, a non display/print character other than space.

Assuming the data is in Cell A1 down, try:

=RIGHT(A1,LEN(A1)-1) if there is one "space" character. Drag the formula
down.

Regards

Trevor


"GAC" wrote in message
...
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?