Converting Names

  • Thread starter Thread starter Lenny Abbey
  • Start date Start date
L

Lenny Abbey

I have a worksheet with many names in individual cells in the following
format:

Glover Walton C


I would like to convert them to "first name" and "last name" cells this
format, so that I can use them for letters in a mailing:

Walton C. Glover


One problem is that there are a number of "Jr."s. I could edit these out by
hand.

Is there a function, or combination of functions that will perform the basic
conversion?

Thanks,

Lenny
 
Lenny,

here is a nice simple formula<vbg>

=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(SUBSTITUTE(A1,"
Jr.",""))-LEN(SUBSTITUTE(SUBSTITUTE(A1," Jr.","")," ",""))))+1,99) & " " &
LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(SUBSTITUTE(A1,"
Jr.",""))-LEN(SUBSTITUTE(SUBSTITUTE(A1," Jr.","")," ",""))))-1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top