Forum Discussion

Copper Contributor

Nov 02, 2019

Convert txt to numbers in excel then change format

Hi Everyone, I have phone numbers in excel that are txt and want to change to numbers. Also need to change format from (000) 000-0000 to 000-000-000. I have several worksheets with these two fo...

excel

SergeiBaklan

Diamond Contributor

Nov 03, 2019

rffEn

Another variant is

with

=REPLACE(REPLACE(REPLACE(A1,1,1,""),4,2,""),7,1,"")+0

if only they are initially not numbers with applied phone number format