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
Comments