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




Reply With QuoteReply With Quote