D
dsrtdrms
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!!!
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!!!