How to Add + Before Mobile Number in Excel | Easy Excel Tip - video Dailymotion

Mr. Devotor

Learn how to easily add a + symbol before mobile numbers in Excel. This simple trick is helpful when working with international phone numbers, including country codes like +92, +91, +1, etc.  In this video, you will learn:  How to use Format Cells (Custom Formatting) to show + automatically  How to use a simple Excel formula to add + before numbers  How to type + manually without Excel removing it  This method works in all versions of Microsoft Excel, including Excel 2013, 2016, 2019, 2021, and Office 365.  If you found this video helpful, Like, Share, and Subscribe 😊  How to Add + Before Mobile Number in Excel | Easy Excel Tip  #ExcelTips #ExcelTutorial #MicrosoftExcel #ExcelTricks #Office365 #DataEntry #ExcelForBeginners #Excelskills #HowTo #Pakistan #India

Transcript

00:00if you are looking for how to add plus before a mobile number in excel then don't skip this video

00:06so for example if i insert a plus sign before mobile number and hit press enter it disappeared

00:17so how you can add first you need to select the data and then right click and go to the

00:24format cells and click on the customs and here is the general you need to type double quote

00:38plus double quote and zero and click okay and you can see plus sign is added before mobile number

00:47so this is the first method the second method is that you need to type

00:55single quote and type plus and type the mobile number so here you can see that plus sign is added

01:07but this method takes a lot of time if you have a big data because you have to put a manual data for

01:15this so if you want to put the plus before mobile number with formula then what you have to do is

01:23you need to press is equal to and double quote plus double quote space bar ampersand space bar and

01:42select the cell and this is what this is the easiest way you just need to drag it and

01:54so with the formula you can easily plus sign before mobile number in the excel

02:00so this way you can easily manage your data so i hope you understand all these three methods if you

02:06you think this video is helpful please support my channel thanks for watching

How to Add + Before Mobile Number in Excel | Easy Excel Tip

Category

Transcript

Be the first to comment

Recommended