Posted to microsoft.public.excel.worksheet.functions
|
|
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
|