Forum Discussion
Phone Number in excel
I want to change a phone number from (555) 555-5555 to 15555555555 how can you do this in excel? I have about 1,000 numbers that I need to change. I have tried data numbers but won't change?
As variant and assuming
- you have texts, not formatted numbers as phone numbers;
- all texts have exactly the same patters;
- your Excel support dynamic arrays
formula could be
=1&CONCAT(MID(A1,{2,7,11},{3,3,4}))
if return text, and
=(1&CONCAT(MID(A1,{2,7,11},{3,3,4})))*1
if return number