Been at this for a few hours researching but need some help. Im trying to separate the following the easiest way possible:
cincinnati atArizona I am trying to separate the teams to there own cell and the at is always attached to that 2nd team name, i can get the first team name in a cell but cant figure out how to do the second team and some teams also have an extra space example atSan Francisco so sometimes theres 2 spaces in the cell. Also have a problem separating
(R) T MAHLE (R) T WIDENER these are in 1 cell so trying to put the letter in the brackets in there own cell and each name in there own cell. Hope i explained it right, any help would be appreciated. Im using office 365.
Thanks in adavance
cincinnati atArizona I am trying to separate the teams to there own cell and the at is always attached to that 2nd team name, i can get the first team name in a cell but cant figure out how to do the second team and some teams also have an extra space example atSan Francisco so sometimes theres 2 spaces in the cell. Also have a problem separating
(R) T MAHLE (R) T WIDENER these are in 1 cell so trying to put the letter in the brackets in there own cell and each name in there own cell. Hope i explained it right, any help would be appreciated. Im using office 365.
Thanks in adavance