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,"")) |
0 Comments