Take JulieD's suggestion one step further. In a blank column next to your
list of numbers enter the formula =VALUE(TRIM(number)) then copy and paste
values over your original column and delete the formula column. This will
remove the extra space and convert it to a number all at the same time.

"JulieD" wrote:

Hi

TRIM should remove the space, however it doesn't necessarily change a
"text - number" into a real number
so TRIM your column in an adjacent column, then copy this column and choose
edit / paste special - values
now click in a blank cell somewhere (maybe on another worksheet) and copy
it - then select this column again and choose edit / paste special - ADD

this should set the numbers back to being numbers.

Hope this helps
Cheers
JulieD

"Cthulhu" wrote in message
...
I have a very simple spreadsheet with two columns of numbers. All I want
to
do is add the numbers, which I understand I can do with the SUM function.

My problem is that each number has a blank space at the end of it, so the
sum function returns a "0" total when adding the columns. I determined I
could delete the blank space at the end of the numbers and the SUM would
work
fine. However the spreadsheet has almost 200 entries and my fingers are
tired.

I cannot seem to get the TRIM function to work, and indenting the cells
has
no impact on the formula working.

How can I get rid of these pesky spaces?

Thank you.