You could also separate it into more columns if you want... such as...
Column B Formula =IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),"")
Column E Formula
=IFERROR(CONCATENATE(TEXT(LEFT(D2,FIND(",",D2)-1),""),", ",TEXT(LEFT(MID(D2,FIND(" ",D2)+1,256),1),"")),"")
Column G Formula
=IF(IFERROR(MATCH(IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),""),$E$2:$E$16,0),0)<>0,"On Roster","Not On Roster")
Looks like this:
![](https://i.ibb.co/KzwvVgm/Roster2.png)