Thread: TRUNCATE SPACE FROM NUMERICAL STRING eg "33 033 546"
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NAEEM NAEEM is offline
external usenet poster
  
Posts: 13
Default 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





Reply With QuoteReply With Quote