Macro Question

[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??

 

[Guest]

The TRIM() function will do exactly what you want

 

[Guest]

I feel dumb but I cannot figure out how to automate the TRIM function to get
rid if the spaces in all the cells

 

[Bob Phillips]

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)