A B C1 Author Last Name First Name 2 Donnely,Paul Donnely Paul 3 Jewell,Tom Jewe Tom B2=LEFT(A2,FIND(",",A2)-1)C2=RIGHT(A2,LEN(A2)-FIND(",",A2))