replace - by blank, keep 0 in phonenumber
Thank you stefi, I will try that
"Stefi" skrev:
Use a Helper column filled with this formula:
=TEXT(SUBSTITUTE(A1,"-",""),"00000000")
format the original column as text and paste special/value the helper column
back to the original column!
Regards,
Stefi
€žsofie€ť ezt Ă*rta:
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!
|