How to Format Phone Numbers with Country Code in Excel

Mr. Devotor

In this video, you will learn how to add a country code to phone numbers in Excel using simple formulas, Flash Fill, and custom formatting. Whether you need to add +92, +1, +44, or any country code, this tutorial will guide you step-by-step.  In this tutorial: ✔ Add country code using formulas ✔ Add country code with space ✔ Use Flash Fill for automatic formatting ✔ Add country code using custom number format  Perfect for Excel beginners, office work, data cleaning, and phone number formatting.  🔥 Hashtags  #ExcelTips #ExcelTutorial #PhoneNumber #CountryCode #ExcelFormula #FlashFill #ExcelTricks #ExcelFormatting #MicrosoftExcel

Transcript

00:00in this video you will learn how to add a country code to phone number in excel

00:05using quick and simple methods whether you want to add plus nine two plus nine one plus double four

00:12or any other country code this tutorial will show you the easiest formula and formatting

00:17tricks if you have lush data and if you do it manually it will take lot of your times and

00:24use this simple formula to add country code put the equal signs and double code and then

00:35add the country code nine two and if you want to give space after country code then hit the space bar

00:45and double code and then ampersand and select the cell and hit enter and here

00:56just will drag the fill handle and the results are in front of you you can see that it's just a matter

01:05of few seconds so there is another method type the nine two before the number and type number

01:23and hit enter two into the next cells and then press ctrl e

01:32and that's all this is the flash fill so you can see that the country code is added so in this way

01:41you can easily enter country code before any number so this is perfect for office work data entry excel

01:48beginners and anyone handling large phone number slits so don't forget to like share and subscribe for

01:54more excel tabs

Category

Transcript

Be the first to comment

Recommended