software

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 Studentquot;ALoecherquot; wrote:

gt; I am a new Excel user and I am having some trouble. I split a column of data
gt; seperated by semicolons into several columns. Now I have a bunch of cells
gt; with a leading space and it is screwing things up when i try to sort
gt; alphabetically. How can i create a macro do delete the leading space in cells
gt; 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

quot;Gary''s Studentquot; wrote:

gt; The TRIM() function will do exactly what you want
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;ALoecherquot; wrote:
gt;
gt; gt; I am a new Excel user and I am having some trouble. I split a column of data
gt; gt; seperated by semicolons into several columns. Now I have a bunch of cells
gt; gt; with a leading space and it is screwing things up when i try to sort
gt; gt; alphabetically. How can i create a macro do delete the leading space in cells
gt; gt; that have such a space??

Select them all and Find and Replace, Ctrl-H, and replace quot; quot; with nothing

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;ALoecherquot; gt; wrote in message
...
gt; I feel dumb but I cannot figure out how to automate the TRIM function to
get
gt; rid if the spaces in all the cells
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; The TRIM() function will do exactly what you want
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;ALoecherquot; wrote:
gt; gt;
gt; gt; gt; I am a new Excel user and I am having some trouble. I split a column
of data
gt; gt; gt; seperated by semicolons into several columns. Now I have a bunch of
cells
gt; gt; gt; with a leading space and it is screwing things up when i try to sort
gt; gt; gt; alphabetically. How can i create a macro do delete the leading space
in cells
gt; gt; gt; that have such a space??