| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
