| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert last, first names to intials
Thanks Gary"s Student - looks like that is what I need.
"Gary''s Student" wrote: If Smith, John is in B3 then: =LEFT(B3,1) & MID(B3,FIND(",",B3,1),3) will display: S, J -- Gary's Student "Brian" wrote: Hi all, Is there an easy way to convert the following cell (lastname, firstname) to (lastinitial, firstinitial) e.g. Smith, John to S, J Thanks Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up names in one excel tab to find a match in another tab | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Replace range names with cell references? | Excel Worksheet Functions | |||
| Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
