| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
RIGHT & MID & LEFT
I have a spreadsheet with all names converted to Last Name, First Name.
Some, not all, of the names have a middle name as well. I have searched postings and Microsoft help and cannot figure out how to return "Smith, John Michael" if I have the name "John Michael Smith". Thank you in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
| Cell Borders and "Columns to Repeat at Left" | Excel Discussion (Misc queries) | |||
| excel organizational chart subordinate goes left not down | Charts and Charting in Excel | |||
| Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
| The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
Threaded Mode
