There is a macro at this link that should be able to clean your data:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Biff
"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?