| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last initial
I am trying to figure out how to extract intials from a name.
The names are in one column in the format of "Frank A Right". I have the first initial extracted and the middle initial extracted, but I can't seem to get the first letter of the last name. So far I have: =UPPER(LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1)). What would I add to this to get the last initial? Thanks Mike Rogers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
| First name, Middle Initial | Excel Discussion (Misc queries) | |||
| Ignoring Initial Articles in Field Sort | Excel Discussion (Misc queries) | |||
| Stripping Middle Initial from a Name | Excel Worksheet Functions | |||
| Extracting Last Name and First Initial | New Users to Excel | |||
Threaded Mode
