Have a look at Chip Pearson's First/Last examples. Also has a downloadable
workbook to go with the examples.

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


Gord Dibben Excel MVP

On Fri, 7 Jan 2005 11:23:05 -0800, "Krexroth"
wrote:

I have a column of names, most of which are FirstName LastName in format.
Some, however are First MiddleName (or MI) Last. I need to convert these
values into LastName Firstname MI. I have a formula that gets close, but
doesn't account for the possible presence of a Middle Name or initial.
For ex, data could be Jill Smith, or Jo Ann Smith. I need to make Smith,
Jill and Smith, Jo Ann.

Seems like I need to go backwards thru the string with a Search function to
find the 2nd space for this to work, but can't. Or should I try it by parsing
consecutive columns with incremental changes together???? Help!

Thank you