Split Different Names with Special Characters

[wnicholl]

I have mutiple name listings that I'd like to only identify First and Last name. Appriciate any help.  The table is attached. 

Split Names

FIRSTNAME LASTNAME

FIRSTNAME LASTNAME 18

FIRSTNAME MIDDLENAME LASTNAME

FIRSTNAME LASTNAME - 18

FIRSTNAME MIDDLENAME LASTNAME CO

FIRSTNAME M. LASTNAME

FIRSTNAME LASTNAME -BR 18

FIRSTNAME M. LASTNAME CO

FIRSTNAME LASTNAME - BR 18

FIRSTNAME O'LASTNAME 66

FIRSTNAME LASTNAME TN

[v-frfei-msft]

Hi @wnicholl ,

Based on my test, I cannot achieve that by Power query. 

[wnicholl]

Ok, thanks for your help.  Much appriciated