Extracting text from a string

[Buzz1126]

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.

[AlKey]

Enter formula in K7 and copy down

=IFERROR(MID(J7,-LOOKUP(1,-FIND({"WR","RB"},J7)),2),"")

v	J	K
6
7	Antonio Brown, Pit WR	WR
8	Todd Gurley, LA RBBreaking News	RB
9	Brandin Cooks, NO WR	WR
10	Ezekiel Elliott, Dal RBBreaking News and Video	RB
11

[Buzz1126]

Works! Thank you!