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

There are instances when we need to remove the country code while working with a collection of phone numbers in Excel. We may exclude those country code prefixes from our dataset to make the work easier. In this post, we’ll examine four quick and simple methods on the topic of how to remove prefix 91 in Excel using the RIGHT, LEN, REPLACE, MID, and SUBSTITUTE functions, among other options.

How to Remove Prefix 91 in Excel: 4 Simple Methods

Let’s assume Column B has a list of phone numbers that begin with 91. By using the RIGHT, LEN, REPLACE, MID, SUBSTITUTE, and other functions, we will get rid of the prefix 91. Here is a summary of the dataset we will be using for this job.

1. Using REPLACE Function to Remove Prefix 91

We can eliminate any cell’s prefix using the REPLACE function. To use Excel’s REPLACE feature to remove the prefix 91 from phone numbers. To learn, kindly adhere to the procedures below.

📌 Steps:

• Now, we will select cell C5 from our dataset as the empty cell into which you will enter the REPLACE function.

• Select cell C5, then enter the following equation in the Formula Bar:

• After that, if you move your cursor to cell C5‘s bottom-right corner, an autofill prompt will appear. Drag the AutoFill symbol downward at this point.

• After dragging the autofill option downward we will see the final data that is shown in the image below.

Read More: How to Remove Prefix in Excel

2. Applying RIGHT and LEN Functions to Remove Prefix 91

Now in this method, we will use RIGHT and LEN functions to demonstrate on the topic of how to remove the prefix 91 in Excel. So, please stay with us and kindly adhere to the process below.

📌 Steps:

• Now, we will select cell C5 from our dataset as the empty cell into which you will enter the RIGHT and LEN functions.

• After inserting the formula, we will press Enter.
• The result will look like the image below.

• At this moment, we have to use the same formula for the remaining cells.
• To do so, drag the fill handle down to the last cell.

• Finally, we got the result that is shown in the image below which will appear after dragging the autofill option downward.

3. Combining MID and LEN Functions to Remove Prefix 91

We have already seen the easy method that will do our task which is removing the prefix 91 from the phone number. However, in this method, we will use MID and LEN Functions to demonstrate the topic of how to remove the prefix 91 in Excel. So, please stay tuned and kindly adhere to the steps below.

📌 Steps:

• Now, we will select cell C5 from our dataset as the empty cell into which you will enter the MID and LEN functions.

• Now just press Enter.
• The result will look like the image below.

• After that, we will apply the same formula to the rest of the cells.
• To complete the process, drag the fill handle down to copy the formula for the rest of the cells.

• Lastly, the final data that is shown in the image below will appear after dragging the autofill option downward.

4. Applying SUBSTITUTE Function to Remove Prefix 91

We have already seen three easy methods in the previous sections. Moreover, we can remove prefix 91 by applying the SUBSTITUTE function by following the necessary steps in the below section.

📌 Steps:

• Now, we will select cell C5 from our dataset as the empty cell into which you will enter the SUBSTITUTE function.

• Now, press Enter.
• The final data will look like the below image.

• Now we have to apply the same formula to the rest of the cells.
• To do so, drag the fill handle down to copy the formula for the rest of the cells.

• Finally, the final data that is shown in the image below will appear after dragging the autofill option downward.

Download Practice Workbook

You can download the practice workbook from the following download button.

Conclusion

Follow these steps and stages on how to remove prefix 91 in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section.