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

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

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

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)

"ALoecher" wrote in message
...
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??