Format a Telephone number
Here is one way...
=TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(A1,"
",""),")",""),"(",""),".",""),"-",""),"000-000-0000")
Hope this helps,
Hutch
"LeeE" wrote:
I want to format the telephone numbers in my excel file so that all look like
this:
508-567-3992 Eg: ###-###-####
Some have parenthesis around the first 3 digits, some have periods after the
3 digits.
I tried creating a custom type in numbers but I think it needs to be a
formula.
Can anyone help?
Thanks
Lee
|