Formula to Split First and Last Names
 

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

Formula to Split First and Last Names
 

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

"Susan" wrote:

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

Formula to Split First and Last Names
 

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

On Thu, 1 Feb 2007 11:26:01 -0800, Susan
wrote:

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