how to extract 10 digit mobile number within text or specialcharacter
-
-
-
Use =RIGHT(A2,10) and copy down
-
-
Thank you it's working perfectly
and one more help if cell have 3 or 4 mobile number how to extract with this formula
-
Thank you it's working perfectly
and one more help if cell have 3 or 4 mobile number how to extract with this formula
One post one question.
Please open a new post for your new question, together with few lines of example data and the expected result.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!