Remove 91 from Mobile Number in Excel: Microsoft Excel is your one-stop platform for saving contact details and other crucial information of your audience. Whether you would like to save the details of specific customers or you need to save the phone numbers of your clients based in international countries, excel is a perfect place to store this data.
There are times when you save wrong information or you enter the details that you want to delete later.
It is quite easy to remove information from excel when you have only a few cells filled with the data.
But, what if you have multiple files or a large single file comprising the list of numbers of different clients?
What if you want to remove certain digits from numbers?
People often save the number of customers and business associates with prefixes in Excel.
For example, they save the number of customers that are based in India with 91 as a prefix. While that is a perfect way to remember the country of the user or separate each customer based on the region they are located in, you may not need this prefix later.
Suppose you want to remove 91 in Excel from multiple cells. How do you remove 91 prefix in Excel? Is there any way to remove country code in Excel?
Well, it is possible to remove +91 from mobile numbers you have entered in excel.
In this post, we will walk you through the steps for removing the prefix digits from Excel.
How to Remove 91 from Mobile Number in Excel
To remove the 91 prefix from mobile numbers in excel, you need to use the MID function.
How to Remove 91 from mobile number in Excel formula:
MID (text, start-position, and length)
Using this function, you could delete 91 prefix from all the mobile numbers present in excel at once. The best part is you can delete the digits from a large number without having to face any penalty. The MID function is mainly used to delete or extract certain characters from the numbers in one click.
Another way to delete 91 from the string of cells in excel is by using the RIGHT and LEN formula in conjunction. Hope this post helped you delete the digits from multiple cells in one click.
Video Guide: How to Remove Country Code or +91 or 0091 or 91 from Mobile Numbers List in Microsoft Excel