How to convert the phone number format to digits in Excel?
Supposing you receive an Excel worksheet contains a list of phone numbers, and now you need to convert these phone numbers to only digits as below screenshot shown. How to achieve it? Please try the methods in this article.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
You can apply the following formula to convert the phone number format to digits in Excel. Please do as follows.
1. Select a blank cell (C2) where you need to place the digits after converting. Then enter formula =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")," ",""),"-","") into the Formula Bar and then press the Enter key to get the result. See screenshot:
Note: In the formula, A2 is the cell contains the phone number you need to convert to digits. Please change it as you need.
2. Keep selecting the result cell C2, drag its Fill Handle down to cell C8 to get all converted digits as below screenshot shown.
Now all phone numbers in the list are converted to digits.
This section will recommend the Remove Characters utility of Kutools for Excel. With this utility, you can convert phone number to digits with ease in Excel.
1. Select the list with phone numbers you need to convert to digits, then click Kutools > Text > Remove Characters. See screenshot:
2. In the Remove Characters dialog box, please check the Custom box, enter a hyphen – into the text box, and finally click the OK button. See screenshot:
Now all hyphens between the selected phone numbers are removed immediately. And now the phone numbers are displayed as digits as below screenshot shown.