Hi every 1. sorry for the excel n00bness here. but i been going round and round with this 1.
ok so i want to break the below cell into HOME TEAM.
296 Tennessee Martin at 2 Ohio St
sometimes they are separated with an "at" or a "vs". i tried to do it in 2 columns, it gives me "VALUE!" but i can't seem to work with that.
=RIGHT(B15,LEN(B15)-SEARCH("at",B15,1)-3) how can you get it to search for "at" OR "vs"
even better would be
"get the text after the sec string of numbers +1"
anyway i bet a bunch of you guys have this worksheet already done, be great if i could get a look at how 1 or 2 of you would have split these cells up.
many thanks
ok so i want to break the below cell into HOME TEAM.
296 Tennessee Martin at 2 Ohio St
sometimes they are separated with an "at" or a "vs". i tried to do it in 2 columns, it gives me "VALUE!" but i can't seem to work with that.
=RIGHT(B15,LEN(B15)-SEARCH("at",B15,1)-3) how can you get it to search for "at" OR "vs"
even better would be
"get the text after the sec string of numbers +1"
anyway i bet a bunch of you guys have this worksheet already done, be great if i could get a look at how 1 or 2 of you would have split these cells up.
many thanks