Extracting all 9 digit numbers from a string

Hello Excel experts,

I have a column of data that may or may not contain multiple 9-digit numbers. I need to extract all of the 9-digit numbers (and only the 9-digit numbers) so that I can use them in other operations. I've been able to successfully grab the first or last, but I can't wrap my head around getting them all.

Examples:

TEXT	Expected Output
#157664855, #158992804	157664855,158992804
161924305	161924305
The bear in 087593184 has 3433 kittens	087593184
Blocked by 162979696	162979696
#123476548, 233059382, and #344094323	123476548,233059382,344094323

Note the delimiter in the output isn't important, as long as there is some delimiter that I can use to further break down the results.

Not sure it's possible with a formula. Here's a UDF that will do it:

Please Login or Register  to view this content.

Usage example:

Please Login or Register  to view this content.

WBD

It's not universal solution because now only for 3and less number for example but add another part is not problem.
Array formula

=SUBSTITUTE(TRIM(
IFERROR(MID(A1;SMALL(IF(IFERROR((TEXT(--MID(A1;ROW($1:$99);9);REPT(0;9))=MID(A1;ROW($1:$99);9))*(TEXT(--MID(A1;ROW($1:$99);10);REPT(0;10))<>MID(A1;ROW($1:$99);10)););ROW($1:$99));1);9);"")&" "&
IFERROR(MID(A1;SMALL(IF(IFERROR((TEXT(--MID(A1;ROW($1:$99);9);REPT(0;9))=MID(A1;ROW($1:$99);9))*(TEXT(--MID(A1;ROW($1:$99);10);REPT(0;10))<>MID(A1;ROW($1:$99);10)););ROW($1:$99));2);9);"")&" "&
IFERROR(MID(A1;SMALL(IF(IFERROR((TEXT(--MID(A1;ROW($1:$99);9);REPT(0;9))=MID(A1;ROW($1:$99);9))*(TEXT(--MID(A1;ROW($1:$99);10);REPT(0;10))<>MID(A1;ROW($1:$99);10)););ROW($1:$99));3);9);"")
);" ";",")