Ad Code

How to remove 91 from mobile number in excel

Worksheet Formulas
Cell Formula
B2 =IF(AND(LEN(A2)=12,LEFT(A2,2)="91"),RIGHT(A2,10),IF(AND(LEN(A2)=10,LEFT(A2,1)="9"),A2,""))

Post a Comment

0 Comments