Remove leading spaces

  • Thread starter Thread starter cs
  • Start date Start date
C

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
 
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
 
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
Click to expand...

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
 
Back
Top