How to Remove 91 from Mobile Number in Excel?

Use `=RIGHT(A1,LEN(A1)-2)` if the number starts with `91`

Use `=SUBSTITUTE(A1,”91″,””,1)` to remove the first `91`

Use `=IF(LEFT(A1,2)=”91″,RIGHT(A1,LEN(A1)-2),A1)` to remove only when it is at the start

Use `=TEXTAFTER(A1,”91″)` if your Excel version supports it and `91` is at the beginning

Fill the formula down for all rows

Copy the results and paste as values if needed

Suggested for You

Trending Today