Split data between numbers and text

[Jaloy_1973]

Hello,

I have a dataset in Excel whose origin is a PDF, and in column G (Extraction 7) I have a lot of text and numeric data, which correspond to Social Security concepts and amounts.
I am trying to transform this data into a detailed table by the different concepts. Once I have separated Column G with the space delimiter, I notice that all the fields are in V-String format. I transpose the data to try to identify the fields containing numbers from those containing text, so that I can further transform the data.
I have more or less succeeded with formulas to identify between the numbers and the text, but in the last filter (false) I notice that data containing numbers appear and it continues to identify them as text. I think it could be some parameter of the formulas but I have not been able to do it.

I attach the workflow, in case anyone has any suggestions or a simpler way to solve the problem.

Many thanks for your kind cooperation,
Jordi

[binuacs · Accepted solution]

@Jaloy_1973 split the records to rows and check for numeric using regex formula

[Jaloy_1973]

Thank you very much for the quick response and solution. This one worked. I only had to make a minor change by adding ‘.’ in the Regex formula to identify the numeric delimiter of the thousands in the Spanish numeric format.

Best regards.

Jordi