I have a column containing names as follows:
Name
MRS SMITH MARY
WALRUS, MR. JOHN J.
MR HARRY C KIRBY
ANDERSON MR.W.
ALDERSON, MR. BARRY.
ALAN, MR. BOBBY K.
MRS GRACE A KELLY
BROWN, MRS. FRANCI A.
As you can see, the human eye can easily detect the salutation, first name and last name (even initials) from this list.
How can I break up this single column into 4 columns - SALUTATION, LASTNAME, FIRST NAME, INITIAL
Also need to remove the erroneous commas etc.
Thanks!
Name
MRS SMITH MARY
WALRUS, MR. JOHN J.
MR HARRY C KIRBY
ANDERSON MR.W.
ALDERSON, MR. BARRY.
ALAN, MR. BOBBY K.
MRS GRACE A KELLY
BROWN, MRS. FRANCI A.
As you can see, the human eye can easily detect the salutation, first name and last name (even initials) from this list.
How can I break up this single column into 4 columns - SALUTATION, LASTNAME, FIRST NAME, INITIAL
Also need to remove the erroneous commas etc.
Thanks!