Hello Experts,

I a newbee in field of excel formula and need your help in a complex formula, where i need to extract phone numbers from a string of random text. This does not have a fix format for the string

Example set off strings:

Dring to data add9724516002
add 08107936777
8726169633 plz add. Me
9767488106 mujhe bhi add karo dosto

I have already tried many formulas but nothing seem to work. Formulas here dont seem to work perfectly -http://www.excelforum.com/excel-formulas-and-functions/1064845-extract-10-digit-number-only-from-text-string.html.

Anmol Dubey