I hope you have not been waiting since June for an answer !! <bg

As your "numbers" are really text values, you can use this formula to
remove the 1<space from the beginning of the phone number (assume it
is in A1):

=RIGHT(A1,LEN(A1)-2)

Hope this helps.

Pete

On Dec 14, 1:00 am, Sherry wrote:
How do I make it remove
the "1" at the beginning of the phone number too.



"Teethless mama" wrote:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," (","-"),") ","-"),"(","")

"Sherry" wrote:

I have telephone numbers that are formatted as (###) ###-####. I need a
formula to change the format to ###-###-####.
Also need the same for telephone numbers that are formatted as # (###)
###-####. Please help. - Hide quoted text -

- Show quoted text -