On Tue, 26 May 2009 04:16:01 -0700, Munfarid
wrote:

I have tried this, but its working in some instances and is not in others..
apparently, the number string contains spaces, and since the formula isnt
working, i guess that these are not 'spaces' at all, rather something
elsen'invisible'

If you have downloaded this data from the web, or an html document, some of the
<space's may really be <nbsp's.

So try

=substitute(SUBSTITUTE(A1," ",""),char(160),"")

--ron