removing spaces in imported document

**xirokx** · 04-29-2008, 01:50 PM

Hi,

I have imported a document into excel and have a column with about 2000 numbers in each cell.

Each cell contains a number, there is a space before each number, I have tried the TRIM, CLEAN and FIND/REPLACE functions but this does not remove the space before the numbers inside the cell...

How can I get rid of the spaces before the numbers in each cell in 1 go without having to click on each cell, hit delete in the formula bar and then press enter to remove the space..

Please help

thanks in advance..

cheers

**NBVC** · 04-29-2008, 01:59 PM

Try copying one of those spaces and select the column to perform the action on.

Then go to Edit|Replace.

In the Find What field paste what you copied.

Leave the Replace With field blank.

Click Replace All

**martindwilson** · 04-29-2008, 02:06 PM

1 it might not be a real space it could be character code 0160
you can easily replace it

alt+f to find /replace as usual
in the search field
hold down 'alt' and type in 0160 (using the number keypad)
release alt
you will see the cursor has moved 1 space to the right
in the replace field enter nothing at all

2.try asap add in under text there is an option to remove leading/trailing spaces if that doesnt work then try in advanced character remove click invisible then spaces and run tool
http://www.asap-utilities.com/

**xirokx** · 04-29-2008, 02:21 PM

thanks guys, I tried the find replace without using the 0160 and holding ALT and it didnt work..

I will report back once I have tried holding the ALT key and type 0160 in...

figures crossed it works..

thanks..

P.S. is 0160 the generic code for removing spaces when working on imported data sheets? or is there another numerical code I could also try?