Below is a table with a column of data that is a mixture of characters and numbers. The numbers appear in multiple places irregularly:

Now we want to extract all the numbers from each row and put them in column B. The expected result is as follows:

Enter in cell B1:

=spl("=?1.words@d().concat()",A1)

Then drag B1 down to every relevant row
Use the words@d to split the string in each row to extract all numbers to form a sequence, and then use the concat to concatenate every number together.

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1659061408754
https://c.scudata.com/article/1659154227982