how to remove 91 from mobile number in excel
Saturday, June 6, 2015
how to remove 91 from mobile number in excel
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,""
)
)
Home
Subscribe to:
Posts (Atom)