How To Change Numbers To Letters On Phone

Excel Tips
Excel Functions
Excel Formulas
Excel Charts
Word Tips
Outlook Tips

How to convert the phone number format to digits in Excel?

Supposing y'all receive an Excel worksheet contains a list of phone numbers, and now you need to convert these phone numbers to only digits as beneath screenshot shown. How to achieve it? Please effort the methods in this commodity.

Convert the phone number format to digits with formula
Catechumen the phone number format to digits with Kutools for Excel

Convert the phone number format to digits with formula

You lot can employ the following formula to catechumen the phone number format to digits in Excel. Please do as follows.

1. Select a bare cell (C2) to output the result, enter the beneath formula into it then press the Enter key.

=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")," ",""),"-","")

Note: In the formula, A2 is the jail cell contains the telephone number you need to convert to digits. Please alter it as y'all need.

2. Go along selecting the consequence cell C2, drag its Fill up Handle down to prison cell C8 to get all converted digits as below screenshot shown.

Now all telephone numbers in the list are converted to digits.

Convert the phone number format to digits with Kutools for Excel

This section volition recommend the Remove Characters utility of Kutools for Excel. With this utility, you tin convert phone number to digits with ease in Excel.

Before applying Kutools for Excel, delight download and install information technology firstly.

i. Select the list with telephone numbers you lot need to catechumen to digits, then click Kutools > Text > Remove Characters.

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 beneath screenshot shown.

If yous want to have a gratuitous trial ( 30-day) of this utility, please click to download it, and and then go to apply the performance co-ordinate above steps.

How to format phone number with extension in Excel?

The Best Part Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by lxxx%

Reuse: Speedily insert complex formulas, charts and annihilation that you have used before; Encrypt Cells with countersign; Create Mailing List and transport emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split up Cells Content; Combine Duplicate Rows/Columns... Forbid Indistinguishable Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Detect in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more than...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (salvage and utilise filter schemes to other sheets); Advanced Sort past calendar month/week/24-hour interval, frequency and more than; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. lx-twenty-four hours money back guarantee.

kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you lot every day!

officetab bottom

Comments (1)

No ratings yet. Be the first to rate!