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
