You can use Text to Columns: DataText to Columns.

Assuming there is a space between names, choose "delimited" and "space"
when running the wizard.

You will probably have to "clean up" a bit with a few names that have
"Jr.", etc.

Hope it helped!


joe Wrote:
I have a column which has names. I would like to split it by Last, First
and
Middle Names. Can some one help me do it.


--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232
View this thread: http://www.excelforum.com/showthread...hreadid=520266