Thread: Changing a list from last name, first name to first name, last name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Changing a list from last name, first name to first name, last name

This is one way

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513402

Reply With QuoteReply With Quote