To prefix mobile numbers with the India country code (+91), use the following methods:

If you want the numbers to display with +91 but need to keep the underlying cell data as a clean 10-digit number for math or sorting operations, use custom formatting. "+91 "########## or "+91 "0000000000 How to use it: Select the column containing your 10-digit mobile numbers. Press Ctrl + 1 to open the Format Cells dialog box.

If you have a table where 91 represents a code or ID and you need to find corresponding data.

If your contact list contains raw 10-digit mobile numbers, use these formulas and formatting tricks to add the country code instantly. 1. The Ampersand (&) Concatenation Formula

The fastest formulaic approach combines the text string "+91" with your target cell using the ampersand operator. = "+91" & A2 How to use it:

If you prefer standard Excel functions over operators, use CONCATENATE or CONCAT . =CONCATENATE("+91", A2)

Remember the three pillars of the 91 methodology:

Excel 91 Formula

To prefix mobile numbers with the India country code (+91), use the following methods:

If you want the numbers to display with +91 but need to keep the underlying cell data as a clean 10-digit number for math or sorting operations, use custom formatting. "+91 "########## or "+91 "0000000000 How to use it: Select the column containing your 10-digit mobile numbers. Press Ctrl + 1 to open the Format Cells dialog box. excel 91 formula

If you have a table where 91 represents a code or ID and you need to find corresponding data. To prefix mobile numbers with the India country

If your contact list contains raw 10-digit mobile numbers, use these formulas and formatting tricks to add the country code instantly. 1. The Ampersand (&) Concatenation Formula If you have a table where 91 represents

The fastest formulaic approach combines the text string "+91" with your target cell using the ampersand operator. = "+91" & A2 How to use it:

If you prefer standard Excel functions over operators, use CONCATENATE or CONCAT . =CONCATENATE("+91", A2)

Remember the three pillars of the 91 methodology: