Thread: How do I format list of names formatted last,first to first last?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default How do I format list of names formatted last,first to first last?

If you want to remove the comma between the names then.


=RIGHT(A1,LEN(A1)-1-FIND(",",A1))&" "&LEFT(A1,FIND(",",A1)-1)

The & " " creates a space between first and last names. I had a ","
there in the last example.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=493420

Reply With QuoteReply With Quote