In this video, I will show you how to convert phone numbers into the right phone number format in Excel. The method you choose would depend on the format of the phone number you get. If you get proper phone numbers as numbers, you can use a simple custom number formatting technique. And if you get the numbers as text, you can use the Text function to do this. In cases where you get messy phone number data where there are additional characters and text with the number, you can use the new regex function in Excel to extract only the digits and then format them. ➡️ Download example file: 00:00 Intro 00:45 Using Custom Number Formatting 05:58 Using TEXT function 07:42 Handling Spaces and Country Codes 09:39 Formatting Messy Phone Number Data 12:20 Formatting Phone Numbers with Extensions ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - ✅ Free Excel Course (Basic to Advanced) - ✅ Free Dashboard Course - ✅ Free VBA course - ✅ Free Power Query Course - ✅ Best Excel Books: Subscribe to get awesome Excel Tips every week: #Excel #ExcelTips #ExcelTutorial #SumitBansal