Format number

  • Thread starter Thread starter Coley
  • Start date Start date
C

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?
 
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
 
Hi,
To remove the blank space in another column enter

=trim(A1)

copy formula down then overwrite the original column with this one
 
Back
Top