| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Format Formula
Use
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) &", " & LEFT(A1,1) This assumes only one space inbetween first and last name. -- If this helps, please remember to click yes. "sross002" wrote: I have a full name in A1 but I want it to read as: Full Last Name, First Name Initial. For example, I would like to convert John Appleseed (a1) to Appleseed, J Thank You in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula x % format | Excel Worksheet Functions | |||
| Format Formula | Excel Discussion (Misc queries) | |||
| formula to format | Excel Discussion (Misc queries) | |||
| sum format in formula bar | Excel Discussion (Misc queries) | |||
| Format\Formula Help | Excel Worksheet Functions | |||
Hybrid Mode
