See also Chip's page
http://www.cpearson.com/excel/FirstLast.htm

But at the end, no computer can tell for sure whether the "Bølla" in "Arnstein Bølla
Cheng" is a part of the first or the last name, or even whether the family name comes last
or first. There's manual auditing to be done.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"TikoTiko" wrote in message
...
The exact problem i'm having is with separating the middle name or middle initial. I can
separate a field with a 1st name and last name but i can make this work whenever it
includes a middle name. Can u include an example of how to solve this problem?