split

Lets say your cell A1 contains Smith, John C.

Then the formula of cell B1 =MID(A1,FIND(",",A1,1)+1,LEN(A1)-FIND(" ",A1)-1) will result John

Formula in cell C1 =LEFT(RIGHT(A1,2),1) will return C

Formula in cell D1 =LEFT(A1,FIND(",",A1,1)-1) will return Smith