There are a few different ways to convert phone numbers in Excel. One way is to use the Text to Columns feature. To use this feature, follow these steps:
Select the cells that contain the phone numbers.
On the Data tab, in the Data Tools group, click Text to Columns.
In the Convert Text to Columns Wizard, select Delimited, and then click Next.
In the next step of the wizard, clear all check boxes under Delimiters, and then click Finish.
Another way to convert phone numbers in Excel is to use a formula. For example, if you have a 10-digit phone number and you want to add parentheses around the area code and a dash between the third and fourth digits, you can use this formula: