=TRIM(A1)

Should do the trick




"Robert Judge" wrote in message
...
Paul:
One more question, please. I now have a column where some of the cells
have
a space as the first character. So, now I need a formula that will
eliminate
the blank space, just leaving the rest of the text in the cell. I will
appreciate advice.

"Paul Corrado" wrote:

Select the cell then use

Copy/Paste Special and select Value

to copy the formula result over the formula. (If it is the entire
column,
just highlight the whole column.)

Also, I should note that the formula posted by NHarkawat was a bit
better
than mine. But I'm glad you were able to use what I gave you.