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