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

"Gary''s Student" wrote:

The TRIM() function will do exactly what you want
--
Gary''s Student


"ALoecher" wrote:

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