Delete spaces from a column

Microsoft Windows xp professional w/serv...
July 29, 2010 at 12:39:36
Specs: Windows XP
Hi,
I have a column where after the last numeric filed comes hundreds of spaces: like
,,'679
I would like to remove all those spaces after 679. I have 1 empty row before and 1 after which is needed.
Please advise me how to reomove trailing spaces on line #2 only.

Thanks


See More: Delete spaces from a column

Report •


#1
July 29, 2010 at 18:46:03
Lets say I have this, where s means a bunch of spaces.

          A
1   
2   ,,'679ssssss
3
4
5   ,,'679ssssss                            
6
7
8   ,,'679ssssss
9

Insert a column next to your values and enter =TRIM(A1) and then drag it down.

          A            B
1                   =TRIM(A1)   
2   ,,'679ssssss    =TRIM(A2)
3                   =TRIM(A3)
4                   =TRIM(A4)
5   ,,'679ssssss    =TRIM(A5)
6                   =TRIM(A6)
7                   =TRIM(A7)
8   ,,'679ssssss    =TRIM(A8)
9                   =TRIM(A9)

This will strip off the trailing spaces but do nothing to the blank cells.

Now select the column with the TRIM formula and do a Copy...Paste Special...Values over the top of your existing values.

Finally, delete the column with the TRIM formula.


Report •
Related Solutions


Ask Question