Extract strings intelligently from single cell

Joined
Feb 18, 2008
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top