Assuming your list in column A, put this formula in B1 and copy down........

=MID(A1,FIND(" ",A1,1)+1,FIND(" ",A1,1)+1)&LEFT(A1,FIND(" ",A1,1)-1)

Vaya con Dios,
Chuck, CABGx3



"dsrtdrms" wrote:

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