Of course there is also the LTrim(), RTrim(), and Trim()
functions that will wipe out all your leading or trailing
spaces, or both. Very handy when dealing with user forms.

Alex

-----Original Message-----
I am just now getting into writing macros so I think this
task may be
above me for now. Could some kind person give me a hint
on writing a
macro that would check for, and if it exists, remove a
single space
that is the first character in a cell from a selected set
of cells.

Many thanks in advance for your time
Andrew
.