Split Different Names with Special Characters

Question

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 · Answer

Hi&nbsp;wnicholl&nbsp;,
&nbsp;
Based on my test, I cannot achieve that by Power query.&nbsp;

wnicholl · Answer

Ok, thanks for your help.&nbsp; Much appriciated&nbsp;

Forum Discussion