How do I resort names
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!!!
|