Macro to remove leading space
Andrew
Why use a macro, when a formula will do?
=if(code(A1)=32,right(A1,len(A1)-1),A1)
HTH
Graham Yetton
-----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
.
|