How to get rid of Spaces after a number in Excel

[DEvOTeEL]

I have copy some data from a website. And copy to Excel Sheet. Now i trying to Sum the total of column but neither Autosum nor Sum Function Work. There are Space after the Numbers. I tried Trim Function but it is not Working. =trim(A1). Anybody can help me.

[Bontu]

There are some changes that can be helped. Try =trim() will return text and =--trim() will coerce things that look like numbers to numbers. But there are other "white space characters" that aren't really spaces: =--trim(substitute(a1,char(160),"")) / =char(160) is that HTML non-breaking space.
But instead of using formulas, maybe you could:

  
select the range to fix
edit|replace:
what: (space character)
with: (leave blank)
replace all

  
and to fix the HTML non-breaking character:
select the range to fix
edit|replace:
what: alt-0160
with: (leave blank)
replace all

Hit and hold the alt key while you type 0160 on the numeric key pad.

[Shurod]

You can substitute fuction for the same. You can try using =SUBSTITUTE(A1," ","")&"". Try this function and just drag the entire content below. This will work out in many cases unless you are not having a large amount of data.