TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

i want to remove space b/w these numbers.


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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

with a formula

=SUBSTITUTE(D26," ","")

--
Don Guillett
SalesAid Software

"NAEEM" wrote in message
...
i want to remove space b/w these numbers.


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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

dear dave
this is not working


"NAEEM" wrote:

i want to remove space b/w these numbers.


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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

dear don this is not working

"Don Guillett" wrote:

with a formula

=SUBSTITUTE(D26," ","")

--
Don Guillett
SalesAid Software

"NAEEM" wrote in message
...
i want to remove space b/w these numbers.


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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

NAEEM

Where did the data come from?

Perhaps the spaces are not regular spaces but html non-breaking spaces.

You could try edit/replace

what: ALT + 0160(on numpad)

with: nothing

Or run David McRitchie's TRIMALL macro found at

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Please note the link to Chip Pearson's CELLVIEW add-in which can show you
exactly which characters are in the cell.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 08:06:01 -0800, NAEEM
wrote:

dear don this is not working

"Don Guillett" wrote:

with a formula

=SUBSTITUTE(D26," ","")

--
Don Guillett
SalesAid Software

"NAEEM" wrote in message
...
i want to remove space b/w these numbers.


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

TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
 

thanks dear

"Gord Dibben" wrote:

NAEEM

Where did the data come from?

Perhaps the spaces are not regular spaces but html non-breaking spaces.

You could try edit/replace

what: ALT + 0160(on numpad)

with: nothing

Or run David McRitchie's TRIMALL macro found at

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Please note the link to Chip Pearson's CELLVIEW add-in which can show you
exactly which characters are in the cell.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 08:06:01 -0800, NAEEM
wrote:

dear don this is not working

"Don Guillett" wrote:

with a formula

=SUBSTITUTE(D26," ","")

--
Don Guillett
SalesAid Software

"NAEEM" wrote in message
...
i want to remove space b/w these numbers.


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