Formula to extract 10 or 11 digit phone numbers from random complex test string

try:

Formula:

=INT(NPV(-0.9,IFERROR(MID(A1,1+LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))),1)/10,"")))

with Control+Shift+Enter
it will extract ALL digits from the string.
If there will be problem with Scientific notation try this one:

Formula:

=LEFT(INT(NPV(-0.9,IFERROR(MID(A1,1+LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))),1)/10,""))),LEN(A1))

with CSE also.

EDIT:
or (just for fun ) you can try with simply UDF function:
1. VBA code
2.

Formula:

=regex(A1,"\d{10,11}")

it will extract 10 or 11 digits only (no more, no less)

Or this regular formula...
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))) Courtesy of:*Ron Coderre

=IFERROR("0"&MID(SUBSTITUTE(A1," ","*")&"a",MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),11)+0,MID(A1&"a",MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),10))

try this formula, hope someone come with better formula