Forum Discussion
rffEn
Nov 02, 2019Copper Contributor
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...
SergeiBaklan
Nov 03, 2019Diamond Contributor
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