Introduce one extra column in which you manually put the name type: 1, 2 or
3
So column A is the name, column B is the type.

Column C:
=CHOOSE(B1,RIGHT(A1,LEN(A1)-FIND("
",A1)),LEFT(A1,FIND(",",A1)-1),LEFT(A1,FIND(" ",A1)))
Column D:
=CHOOSE(B1,LEFT(A1,LEN(A1)-LEN(E1)),RIGHT(A1,LEN(A1)-LEN(E1)-1),RIGHT(A1,LEN(A1)-LEN(E1)))

Copy both down as far as needed

--
Kind regards,

Niek Otten

"data_diva" wrote
in message ...

I can check the names in a system and pretty much am familiar with the
employee names, its just that they are in all formats in one column and
I need them all to go the same way.


--
data_diva
------------------------------------------------------------------------
data_diva's Profile:
http://www.excelforum.com/member.php...o&userid=28885
View this thread: http://www.excelforum.com/showthread...hreadid=486339