Remove leading spaces

[cs]

I have a spreadsheet where for whatever reason, a lot of
the data has leading spaces. I don't know how to program
macros so I was wondering if there is some trick I haven't
heard about that will allow me to remove those spaces in
the columns they appear in. Thanks for the help

 

[Patti]

Hi-light the column and then try Data -- Text to Columns --
Finish

 

[Ken]

If your data is in A1, in B1 enter
=TRIM(A1) to get rid of the leading spaces.

Copy B1 down for all the rows in column A.

Then highlight column B, select copy and then Paste
Special...Values. You can then delete column A.

HTH

 

[hgrove]

cs wrote...

I have a spreadsheet where for whatever reason, a lot of the
data has leading spaces. I don't know how to program macros
so I was wondering if there is some trick I haven't heard about
that will allow me to remove those spaces in the columns they
appear in. Thanks for the help

If these columns didn't have other spaces, you could select each suc
single column range, run Data > Text to Columns, choose Fixed Width an
immediately press the Finish button