Help with Parsing Text within Column

[kkkim]

Hi! I am trying to parse words/numbers into two columns. 

Example below

Shirt White 5,000 Pants Yellow 10,000 --> Need to separate into 2 columns 1) Shirt White 5,000 and 2) Pants Yellow 10,000

Pants Black 2,000 Shirt Purple 200,000 --> Need to separate into 2 columns 1) Pants Black 2,000 and 2) Shirt Purple 200,000

Shirt Red 1,000 Pants Green 13,000 --> Need to separate into 2 columns 2) Shirt Red 1,000 and 2)Pants Green 13,000

So Shirt and Pants are always present in a single column.  And they are essentially separators for the two columns.

Any ideas are much appreciated!

Thank you so much!!!

[OllieClarke · Accepted solution]

Hey @kkkim RegEx is your friend here:

This RegEx makes column 1 out of everything before the first space after a number, and column 2 out of everything after that space up to (and including) the final number

Hope that helps,

Ollie

[kkkim]

This worked perfectly!!! Thank you!

[OllieClarke]

@kkkim glad I could help 🙂