Thread: creating last name first, first name last from a column of first name last name data
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JasonK[_3_] JasonK[_3_] is offline
external usenet poster
  
Posts: 38
Default creating last name first, first name last from a column of first name last name data
thank you -- worked perfectly
jasonK



On Mon, 27 Jul 2009 02:25:08 -0400, "Rick Rothstein"
wrote:

Give this formula a try...

=MID(A2&", "&A2,FIND(" ",A2)+1,LEN(A2)+1)

Change the A2 to the cell address of the cell containing your first set of
names and then copy it down.

Reply With QuoteReply With Quote