View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dsrtdrms dsrtdrms is offline
external usenet poster
 
Posts: 1
Default 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!!!