Hai i am new to OzGrid Forum
How to Extract 10 Mobile Numbers to Separate Columns with any Single Formula
how to extract 10 digit mobile number within text or specialcharacter
-
Use =RIGHT(A2,10) and copy down
-
B2, copied across right and all copied down :
=MID($A2,FIND(B$1,$A2)+LEN(B$1)+2,10)
-
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!