Excel Formula needed: Find Phone Number(s) in a string

Good afternoon all,

I have a problem that I am sure this amazing community will solve (almost immediately no doubt). I would love to have a formula to do this all. I really don't want to have to convert text to columns if possible.

For this example,

In the first column I have a variable text string. In some cells there is no phone number, in other cells there is 1 phone number and in other cells there are 2 phone numbers. (There are never more than 2 phone numbers)
In the second column I would like to return the first phone number if present however phone number suffix not required (ie do not return "+12")
In the third column I would like to return the second phone number if present (also not returning the "+12"). Blank if not present.
The original and preferred outcome is below:

Original:
Phone Problem.jpg

Outcome:
Phone Solution.jpg



Session DNIS

tel:+1234567891; tel:+1234567892
tel:+1234567893
tel:+1234567894; sip:randomstring;morerandomstrings;evenmorerandomstring; tel:+1234567895



I hope this makes sense. Please reach out if you have any questions!

Thanks for your time

If your Excel is updated to Excel 365 in the meantime:

First number: Please try and copy down:

Formula:

Please Login or Register  to view this content.

Second number: Please try and copy down:

Formula:

Please Login or Register  to view this content.

Administrative Note

Please don't ignore contributors to your thread - it takes members time to provide suggestions, so acknowledge all solutions offered, even if they don't meet your requirements. Thanks.

You are Welcome!

Thanks for the feedback and rep .

Glad to have helped.