If it's not working, then maybe you don't have spaces in those strings.

If you copy|pasted from a web page, you could be getting those HTML non-breaking
spaces.

You can insert a new column and use a formula like:

=substitute(a1,char(160),"")
(It returns text values--not numbers)

or
=--substitute(a1,char(160),"")
(to return a real number)



NAEEM wrote:

dear dave
this is not working

"Dave Peterson" wrote:

Select the range
edit|Replace
what: (space bar)
with: (leave blank)
replace all



NAEEM wrote:

i want to remove space b/w these numbers.

3 087 159
33 033 546
63 330
69 031
13 115 606


--

Dave Peterson


--

Dave Peterson