View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raymie Younkin Raymie Younkin is offline
external usenet poster
 
Posts: 1
Default Flipping Names in same cell

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

Where C3 is the cell with the name formatted as

Smith, John