Extracting the date from the title

[suds144]

Hi Everyone,

I have been trying to use the "test to columns" tool to extract the date from the title but I'm unable to extract the date the way I want.

Output

Input

Thank you :)

[suds144]

Thank you! This partially worked but not all were split. There are still some events appearing with the date in the title? 

[EN6924]

Extracted the date in a separate column from your given input -

[suds144]

Thank you!. Would the formula have to be different if there is a "?" in the title or if there were no spaces between the date and the title? I'll review and detail and see. 

Honestly been scouring the forum (and google) for tips. Must be my lack of knowledge and familiarity with the tool.