excel woes

xirokx · 29 Apr 2008 at 18:11

Hi,

I have a column of numbers in excel that has a space before each number inside each cell, the only way to remove the space is by clicking on the cell and then pressing backspace and then enter, but trouble is I have only 2000 cells like this, is there a formula I can use to do this automatically?

I have tried left indent etc but still didnt work..

pls help me solve this

thanks in advance..

cheers

Participant · 29 Apr 2008 at 18:16

=TRIM(A1)

xirokx · 29 Apr 2008 at 18:23

that doesnt do it

that will only do 1 cell at a time, i need to do 2000 numbers in a lot of cells...

is it because the data has been imported?

Goksly · 29 Apr 2008 at 19:12

Put the Trim command in cell A2. Drag it down and you will be able to apply that formula to all the cells in like 5 seconds.
Best solution is to get the program that produces the data to trim it before exporting it.

Participant · 29 Apr 2008 at 19:15

xirokx said:
that doesnt do it

that will only do 1 cell at a time

LOL :/