Extraction

[RIZVI]

Hi Rick Rothstein ,

I also had a similar query. With this formula, can the mobile numbers that are 10 digit and telephone numbers that are 7 digit can also e extracted? Secondly what if there are more than one number that needs to be extracted separated by a comma?

The sample data is given below. The data can have zip codes, and fwe numeric in e-mails, like some one can hv emial ID as rizvi123@xyz.com. There can be door number,s house number,s street numbers.

Sample Data in Cell:

Zeeshan Kazi, Zahur Kazi, Sachin Kanungo, Sunil K, Vishwas Kulkarni 023152223077, 07276389379, 9923113882, +917676958383(+1), 09379905494(+3) Sunil.K@adaniwilmar.in, vishwas.kulkarni@adaniwilmar.in , Survey No.5, 6&7, Baikampady Industrial Area, MANGALORE KARNATAKA -575011, sachin.kanungo@adaniwilmar.in , Survey No 5, 6 e 7 Baikampady Industrial Area Mangalore 5 Karnataka, India 575011
RGDS,

Rizvi.M.H.

 

[Peter_SSs]

Rather than hijack somebody's current thread, please ask in your own thread. Simply put a link the the thread you are referring to.

As you can see I have moved your post this time.

BTW, are those real email addresses and contact details? Refer to #11 of the Forum Rules
If they are, post back and I will modify them.

 

[RIZVI]

Dear Peter_SSs

Pardon my excess, but I am really very technologically challenged. I have not done it intentionally and did not realize that it amounts to hijacking.

Secondly I am not able to see where the post has been moved to. While these are real contact details but are very old, approximately 4 to 5 years and I think those people may not be now having the same details.

Thirdly after post my query as new thread, how do I inform you or tag you, so that you become aware.

Anyways I am positing it as new thread. Some days back also I had posted and someone responded also but answer was not satisfactory.

Once again I apologize. This forum has been a blessing to me and won't like to rub anyone on wrong side here.

RGds,

Rizvi.M.H.

 

[RIZVI]

HI Peter_SSs

http://www.mrexcel.com/forum/excel-questions/948233-extracting-info-cell.html#post4554931

I have posted the query as new link above. Request you humbly to please look into it.

RGDS,

Rizvi.M.H.

 

[Peter_SSs]

Secondly I am not able to see where the post has been moved to.

In that case, how did you reply to it here?

Thirdly after post my query as new thread, how do I inform you or tag you, so that you become aware.

You don't. You just have to take your chances that somebody will answer.

Anyways I am positing it as new thread. Some days back also I had posted and someone responded also but answer was not satisfactory.

In that case you should have responded in that original thread with further details, not started a new one. Refer to #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines

This forum has been a blessing to me and won't like to rub anyone on wrong side here.

Then please make yourself familiar with the rules and guidelines and ensure that you abide by them in future.

This thread is now closed.