Thread: how can i remove all spaces in a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default how can i remove all spaces in a number
how can i remove all spaces in a number

This will remove all spaces from the value in A1 whether it's a number or
not...

=SUBSTITUTE(A1," ","")

Rick

Reply With QuoteReply With Quote