I assume you meant [+1 (###) ###-####]
If this is a text format and you want it an a numerical format
try
=value(mid(A1,6,3)&mid(A1,10,3)&mid(A1,15,4))
and set the custom format as 000-000-0000
You may have to play with the start points in the Mid () I can't tell
whether there are some spaces there
If you want a text output try
=mid(A1,6,3) & "-" & mid(A1,10,3) & "-" & mid(A1,15,4))
with the same comment on starting place.


"Mikey54412" wrote:

Is there a way to convert an existing phone number format [+1 (###) ###-###]
to this type of format ###-###-#### without rekeying the numbewrs