View Single Post
  #4   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 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