See if the information on Chip's page here will help

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

wrote in message
oups.com...
Hi everyone,
I have a column of proper names, some of which have middle initials and
some of which do not. I am trying to get them into columns of | first
name | MI | Last Name |. The problem is that excel seperates them into
three columns with the last name in the middle column for people
without middle initials, and the last name in the third column for
people with middle initials. I would appreciate any help you excel
experts could give me.