Thread: a formular to remove spaces in a numeric cell (Phone No)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi Bondi is offline
external usenet poster
  
Posts: 94
Default a formular to remove spaces in a numeric cell (Phone No)

Joco wrote:
I want to create a formular in a new numeric cell that removes spaces from
another cell ie 0800 123 456 result 0800123456

Hi Joco,

Maybe you can use something like this if your phonenumber is in A1

=SUBSTITUTE(A1," ","")

Regards,
Bondi

Reply With QuoteReply With Quote