I've got a cells B4 - B300 with text (I think these two examples cover the different amount of spaces):

Antonio Brown, Pit WR
Todd Gurley, LA RBBreaking News
Brandin Cooks, NO WR
Ezekiel Elliott, Dal RBBreaking News and Video

I need to extract the players position and put it in a column of its own. For instance I need to get "WR" from Antonio Brown, and "RB" from Todd Gurley.

Does anyone know how to do this?

=MID(J7,FIND(",",J7)+FIND(" ",J7),2)

works for Gurley, but not for Brown. I need one that works for all of them.