Share via

How to reformat phone numbers in excel?

Anonymous
2025-06-10T13:08:39+00:00

I have a spreadsheet in excel with a column of phone numbers formatted as (123) 456-7890. Is there a method to change the format to 1234567890 for the entire column so that I don't have to go cell by cell to reformat them?

My version of Excel is: Microsoft® Excel® for Microsoft 365 MSO (Version 2505)

Thank you in advance!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2025-06-10T13:54:14+00:00

    Image

    Hi,

    Apply below formula in cell B2:

    =BYROW(A2:A4, LAMBDA(a, --TEXTJOIN("",, REGEXEXTRACT(a, "\d+", 1))))

    An alternative formula is this:

    =--REGEXREPLACE(A2:A4, "\D+", "")

    If the numbers you may have in column A are formatted as phone numbers, then you will need to go to Format Cells > Category > General > Ok. This procedure returns them to normal numbers.

    HTH

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-06-10T13:22:47+00:00

    Dear Ashton 

    Thank you for reaching out to the Microsoft Community. We are happy to assist you.

    Regarding your issue, you can try this formula to change your phone numbers format in Excel:

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"-","")," ","")

    After using this formula, you can drag this formula down the column to apply it to all phone numbers.  If needed, you can copy the new column and paste as values over the original column to replace the data. 

    Please give it a try and let me know if it works

    Best regards,  

    Jess - MSFT | Microsoft Community Moderator

    0 comments