How To Clean & Split Dirty Data In PowerQuery

Surendra Reddy on Linked posed a challenge on how to Clean & Split Dirty Data as shown below

There are many ways of doing this but I find it easy to use below Power Query M code

let 
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], 
clean = Table.AddColumn(Source, "clean", each Text.Select([Messy Data],{"a".."z","A".."Z","0".."9"})), split = Table.SplitColumn(clean, "clean", Splitter.SplitTextByCharacterTransition({"a".."z"}, {"A".."Z"}), {"First", "Last"}) 
in 
split

See the below video for an explanation

DOWNLOAD WORKSHEET