Thread: counting spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dstiefe dstiefe is offline
external usenet poster
 
Posts: 73
Default counting spaces

I have a column full of names...the problem is there is random spacing before
the name...for example: " name" and in others it may be " name" while
others are " name"

how do I first count the number of spaces? then delete them so the name is
at the far left?

thank you