Formula to Split First and Last Names

[Susan]

Can someone please tell me a formula that will split last names, first names
and middle initial or middle name in that order within a cell. No commas or
periods are used.

Susan

 

[Hamster07]

Funny Susan, I just asked this in another thread. Highlite the column then
Try "Data" "Text to Columns" and follow the prompts.

 

[Gord Dibben]

Susan

Have a look at how Chip Pearson does it.

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

Note also: Chip has provided a sample workbook.

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

Scroll down to "FirstLast"


Gord Dibben MS Excel MVP