Hello, daddylonglegs!
You wrote on Mon, 9 Oct 2006 15:31:02 -0700:

d =CLEAN(A1)

d "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?

I tried that and it does not work. CLEAN removes non-printable
characters according to HELP

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not