How to separate area code from phone number in Excel?
If you have a list of clients' phone numbers in a worksheet, and you want to divide them based on their areas, you need to separate the area codes from their phone numbers first. Now, I tell you two quick ways to separate the area codes from phone numbers in Excel.
Recommended Productivity Tools for Excel
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 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
In general, the area code is the first three numbers of the phone number, so you can use the follow formula:
Select a cell and type this formula= MID(B1,1,3) ( B1 is the cell you want to separate the area code from), and press Enter button, then drag fill handle to fill the range you want to apply this formula. See, the area codes are extracted from the phone numbers list:
In Excel, you also can use Text to column feature to finish the separating.
1. Select the list of phone number, click Data > Text to Columns. See screenshot:
2. In the Convert Text to Columns Wizard dialog box, check Fixed width and click Next. See screenshot:
3. Then set your field width by setting the break lines with arrow. See screenshot:
4. Click Finish. Then you see the area codes are separated from the full phone numbers