Splitting a string with no delimiter and non-formatted data

[billbillz]

Hi all,

I need to separate some data into number and description however the data is extremely unformatted making it hard to use text to column.

Heres an example of the types of data:

Cat food 5005

6003 - Dog Food

Hamster Food - 9002

Big dog food 2002

S.A chinchilla food 2030

If anyone has ideas of how to split this so example

column 1- 5005 then another column with Cat food 

Hope that makes sense!

Thanks in advance 

[aatalai]

create two columns with the same data (use the formula tool). Then 2 data celanese one for each column, one to remove numbers and one to remove letter (also adjust for puncations and things accordingly in the data celanese settings.

[MilindG · Accepted solution]

@billbillz Regex should work.