How do I separate a column that contains a variable number of digits and chars?

Hello everyone,

I have a column on a document that contains arrays in the following format: [variable_number_of_digits][variable_number_of_chars]. Example:

123wordI
3456word
123wordw
3456wordword
65575word
65784wordwordword

How can I extract the numbers from that column? Note that the digits and chars are not mixed. I cannot use Split to columns or LEFT function due to the variable lenght. I managed, however, to separate them by filtering the column, manually checking the arrays containing only 3 digits, then I used LEFT function, then repeat for arrays with 4 digits, etc - but it takes a lot of time.

Please help me solve this issue.



Many thanks,
Syno

Wow, amazing.
You saved me a lot of time!
Many many many thanks!!!!!!!!!!!!

Is it too much if I ask you to explain the logic of the formula?

to get the number (any digits)
=LEFT(A1,SUMPRODUCT((ISNUMBER(--MID(A1,ROW($1:$10),1))*1)))
to get the text
=SUBSTITUTE(A1;LEFT(A1;SUMPRODUCT((ISNUMBER(--MID(A1;ROW($1:$10);1))*1)))