How to Remove +91 in excel sheet

Home / How to Remove +91 in excel sheet

How to Remove +91 in excel sheet

April 9, 2019 | Excel | No Comments

How to Remove +91 in excel sheet is a very common question for everyone. There are several ways in which excel can remove +91 India country code.
First of all, you need to add +91 mobile number to excel in cell A after that paste a command of excel into an adjacent column
=RIGHT(A1,10)
After paste you select the command of that excel and scroll down your career as soon as you scroll down, you will see that +91 getting removable in the adjacent column and your mobile number will be removed.
In this column, the number of +91 out has been removed, select the cell number to remove +91 once you have selected, copy it, after copying, click on the right click right-click after clicking on the number three option special paste after the click special paste, you will open a pop on it by clicking on the value and pressing the OK button you can use Ctrl+N to add new page then Ctrl+V with help of a new page you will be able to see that your +91 number has been removed and the 10digit mobile is visible to you.


= RIGHT(A1,10)
This command can be used only for India’s number want to remove code for that country for the country’s code mobile number. Let me give you an example through how to use this command to remove the second country code.
Take for example
The mobile number in US country is in 9 digits and country code is +1
Believe that it is a US number +1 999999999. This command will be used to remove the excel =RIGHT(A1,9)
a command is displayed like this
= (its means equal)
RIGHT (its means directly by hand)
A1 (its means cell A column 1)
9 (it means the number in the mobile number)
in the example, you can understand
If you want to remove the country code form any excel sheet, you can remove the country code using the command. If you want to remove +91 number form India, then you have understood how to remove +91 and how t use the code different countries

, ,

About Author

Leave a Reply

Your email address will not be published. Required fields are marked *