Macro Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
I feel dumb but I cannot figure out how to automate the TRIM function to get
rid if the spaces in all the cells
 
Select them all and Find and Replace, Ctrl-H, and replace " " with nothing

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top