Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This is stumping me - I have a large database list that has multiple
names listed with Last Name first, First Name and Middile Initial last (if availiable) then backslash 2nd or more names - same format as 1st name - all w/out commas. How would I do following - Eliminate all but the first named and reformat to First Name, Last Name and no MI - Example - BEHRENS LAWRENCE W/JEANNE SEDELLO/E - Reformatted to - LAWRENCE BEHRENS. I assume it would take mutiple steps - elimination, comma entry and name reformat as at this point I am going to have to manually eliminate the multiple names then apply formulas. Any assitance would be greatly appriciated!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
Convert Local Names to Global Names | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |