Thread: Macro Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ALoecher
 
Posts: n/a
Default Macro Question

I am a new Excel user and I am having some trouble. I split a column of data
seperated by semicolons into several columns. Now I have a bunch of cells
with a leading space and it is screwing things up when i try to sort
alphabetically. How can i create a macro do delete the leading space in cells
that have such a space??