View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Graham Yetton Graham Yetton is offline
external usenet poster
 
Posts: 3
Default 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
.