View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sofie sofie is offline
external usenet poster
 
Posts: 7
Default replace - by blank, keep 0 in phonenumber

Hi! I need to format a series of swedish phonenumbers from, for example
045-52698 to 04552698. When I try to use the search and replace, I lose the
0 in the beginning of the number. I also tried to format the cells as text
first, but it doesn't help.

Can anyone help?

Thanx!