Hi,
I'm working on a list of rugby results where column A contains the fixture "Team A v Team B".
I want to separate the teams from column A and put the teams into 2 cells. I've been messing about with the LEFT, RIGHT and FIND functions and managed separate the home team, but I get undesirable results for the away team.
EG!
Cell A2
"All Blacks v France"
Cell D2: home team
=LEFT(A2,FIND(" v ",A2)) Result= "All Blacks" <---Happy days!
Cell E2: Away team
=RIGHT(A2,FIND(" v ",A2)) Result= "ks v France" <-----Booo!
I've reached the ends of both my excel skills and my google search skills, advice gratefully appreciated.
I'm working on a list of rugby results where column A contains the fixture "Team A v Team B".
I want to separate the teams from column A and put the teams into 2 cells. I've been messing about with the LEFT, RIGHT and FIND functions and managed separate the home team, but I get undesirable results for the away team.
EG!
Cell A2
"All Blacks v France"
Cell D2: home team
=LEFT(A2,FIND(" v ",A2)) Result= "All Blacks" <---Happy days!
Cell E2: Away team
=RIGHT(A2,FIND(" v ",A2)) Result= "ks v France" <-----Booo!
I've reached the ends of both my excel skills and my google search skills, advice gratefully appreciated.