Phone numbers to extract

Hello All,

I have a report coming from a phone system which more or less looks like this:
Sorry. Your message to phone number 215-555-2210 could not be delivered. Your recipient did not answer or might be busy. Please try again later.


I need to extract the phone number and put it in a separate column to be able to block future calls to.

I tried different forumlas to no avail.

Any help would greatly be appreciated.

Thanks,
Mike

With a sentence in cell A1, use the following array formula:

=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$999),1)),0),12)

An array formula is entered with CNTRL-SHFT-ENTER rather than just the ENTER key.

(In the Formula Bar, the formula should appear surrounded by braces)

Your sentence may be long.......Use this instead:

=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$999),1)),0),12)


See the attached working example:

Try this one

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),12)

Thanks for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

Try:

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",255)),SEARCH({1,2,3,4,5,6,7,8,9,0},SUBSTITUTE(A1," ",REPT(" ",255)))-255,500))