Thread: Changing: Last, First to First Last name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Changing: Last, First to First Last name
One way:

=TRIM(MID(A1,FIND(",",A1)+1,255) & " " & LEFT(A1,FIND(",",A1)-1))



In article ,
Charlie7805 wrote:

Can this be done?

Doe, John to John Doe
Reply With QuoteReply With Quote