# How to Remove Prefix 91 in ExcelÂ (4 Easy Ways)

Column B has a list of phone numbers that begin with 91. We’ll remove the prefix.

### Method 1 – Using the REPLACE Function to Remove Prefix 91

Steps:

• Select cell C5.

• Enter the following formula in the Formula Bar:
`=REPLACE(B5,1,2,"")`

Formula Explanation:

• B5 refers to the cell from which you wish to delete the country code 91 prefix,
• 1 designates that the replacement will happen from the first character,
• 2 designates how many characters are removed
• (“”) designates the characters you’re inserting instead.

• If you move your cursor to cell C5‘s bottom-right corner, an AutoFill icon will appear.
• Drag the AutoFill symbol down.

• Here’s the result.

Read More: How to Remove Prefix in Excel

### Method 2 – Applying RIGHT and LEN Functions to Remove Prefix 91

Steps:

• Select cell C5Â and enter the following formula:
`=RIGHT(B5,LEN(B5)-2)`

Formula Explanation:

• B5 refers to the cell from which you wish to delete the country code 91 prefix,
• The RIGHT function indicates that the characters of the text will be taken from the last character.
• LEN(B5) counts the number of characters of the cell B5 which is 12.
• LEN(B5)-2 indicates that the resultant text will have (12-2) or 10 characters without the first two characters of the referred text (B5).
• Press Enter.

• Drag the fill handle down to the last cell.

• Here’s the result.

### Method 3 – Combining MID and LEN Functions to Remove Prefix 91

Steps:

• Select cell C5Â and insert the following formula:
`=MID(B5,3,LEN(B5)-2)`

Formula Explanation:

• 3 designates that the MID function will start extracting from the third character.
• LEN(B5)-2 indicates that the resulting text will have (12-2) or 10 characters without the first two characters of the referred text (B5)
• Press Enter.

• Drag the fill handle down to copy the formula for the rest of the cells.

• Here’s the result.

### Method 4 – Applying the SUBSTITUTE Function to Remove Prefix 91

Steps:

• Select cell C5Â and insert the following formula:
`=SUBSTITUTE(B5,"91","",1)`

Formula Explanation:

• “91” indicates that 91 will be replaced
• Â (“”) designates that the replacement is empty
• 1 indicates that only the first appearance of “91” will be substituted
• Press Enter.

• Drag the fill handle down to copy the formula for the rest of the cells.

• Here’s the result.

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF