Format number

[Coley]

I need to do calculations on a column of numbers I have imported(copy &
paste). The calculations do not work and I have discovered that the numbers
have a leading blank space. I have tried to format as number but does not
work. If I edit each cell and remove the leading blank space all is well.
This is too time consuming. How can I format or edit more effeciently?

 

[T. Valko]

Try using Edit>Replace

Select the range of cells that hold the numbers
Goto the menu Edit>Replace
Find what: enter a space by hitting the space bar
Replace with: nothing, leave this blank
Replace All

 

[Eduardo]

Hi,
To remove the blank space in another column enter

=trim(A1)

copy formula down then overwrite the original column with this one