Chip Pearson's site deals with this nicely.

Provides a downloadable workbook with examples if you want it.

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


Gord Dibben MS Excel MVP


On Sat, 15 Jul 2006 16:15:02 -0700, kikilein
wrote:

I have a column of names first name, middle initial (sometimes), last name.

I have a hard time to separate that middle initial that some of the names
have but not all. I tried the Data text to column but have a hard time
seperating the middle intitial. Any ideas on how to do it?

Thanks much.