Thread: how can i remove all spaces in a number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how can i remove all spaces in a number
If you have a range of these to fix, you could:
Select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all



allahyari wrote:

how can i remove all spaces in a number

--

Dave Peterson
Reply With QuoteReply With Quote