| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Always better if you specify what you want in advance, so that the
question only has to be answered once. You don't say where you want the middle initial to be included... If with the first name, one way: =LEFT(A1,FIND(".",A1)+1) In article , chellegar wrote: What about if there is a middle initial? Ex. Jane A. Doe What will be the formula so that the middle initial will be included? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| cell formatting problems | New Users to Excel | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| Import Data into same cell | Excel Discussion (Misc queries) | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
Threaded Mode
