seperate a full name into first, middle, last, & suffix column

I

ichihina

Names that I want to seperate would be:

John A Doe Sr.
Sandy Park Jr.
Dan A Kim
Delma J. Smith Jr.
Bon Le mont Gu (middle name: Le mont, last name: Gu)
Oscar De la Renta (last name: de la renta)

If you can also write a macro for this, please feel free to write one.

Action that I would take : select the column that contains full names

What I want the macro to do: add 4 columns to the right (First name,
middle, last, & suffix column) with missing values left blank.
 
J

JE McGimpsey

See

http://cpearson.com/excel/FirstLast.htm

For some ideas. The primary problem is to define which part of a name a
particular segment belongs to.

Given your data, you'll have to explicitly specify at least certain
names. There's no way XL (or a human being) can inherently tell that
the names should be parsed as

Bon | Le mont | Gu
Oscar | | De la Renta

without making a specific exception for each name.
 

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

Similar Threads

Parsing full name into salutation, First, middle, last, Suffix 1
Separate first name, middle name and last name 2
parsing a full name out into Last, First, Middle 2
Full Name + Suffix Displays out of order 0
How do I seperate a full name field out into three seperate columns? 3
Extract first names, middle names, last names and JR/SR 8
Separate First Name MI and Last Name into three Cells 1
Separating Full Names into First Middle and Last 1

Top