I have been trying to get two of my formulas to work together to remove the @ sign in a sport schedule (so all I am left with is the opponent's team name).

When I have UCLA @ Staples Center, I just want UCLA. I have accomplished this with:

Formula: copy to clipboard
=IF(FIND("@",B19)>2,LEFT(B19,FIND("@",B19)-2),B19)


When I have @ UCLA, I just want UCLA. I have accomplished this with:

Formula: copy to clipboard
=IF(LEFT(B8,1)="@",MID(B8,3,LEN(B8)-1),B8)


When I try and combine the two together (to handle either situation), I get a #VALUE error:

Formula: copy to clipboard
=IF(LEFT(B8,1)="@",MID(B8,3,LEN(B8)-1),IF(FIND("@",B8)>2,LEFT(B8,FIND("@",B8)-2),B8))


If I add the last Value_if_False statement, I get the error "You've entered too many arguments" which isn't really the case, the problem is the FIND statement produces the #VALUE error:

Formula: copy to clipboard
=IF(LEFT(B8,1)="@",MID(B8,3,LEN(B8)-1),IF(FIND("@",B8)>2,LEFT(B8,FIND("@",B8)-2),B8),B8)


I have been racking my brain trying to figure out another way to do this and nothing is coming to my mind. Any Ideas?

Thank you in advance!