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