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:
=IF(FIND("@",B19)>2,LEFT(B19,FIND("@",B19)-2),B19)
When I have @ UCLA, I just want UCLA. I have accomplished this with:
Formula:
=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:
=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:
=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!
Bookmarks