I used a few split text functions, (aka: right, left, find) and split the text into what I finally wanted. Now I want the new column of text to equal another column and only some of the text is matching up. For example, it kind of looks like this:
First Column Split Column Abbr Abbr Match Result
singled to shortstop (2-2) singled to shortstop S6 singled to shortstop S6
flied out to cf (1-0) flied out to cf FO8 flied out to cf blank
So basically, whenever the split column equals the abbr match column, I want the result column to equal the abbr column. My issue is that sometimes it works and sometimes it doesn't and there doesn't seem to be a distinction as to why. I've seen if one cell equals another one, and the same thing happens, sometimes they're equal, sometimes they're not. I hope you can help and if I wasn't clear, I can try to explain another way. Thanks!
First Column Split Column Abbr Abbr Match Result
singled to shortstop (2-2) singled to shortstop S6 singled to shortstop S6
flied out to cf (1-0) flied out to cf FO8 flied out to cf blank
So basically, whenever the split column equals the abbr match column, I want the result column to equal the abbr column. My issue is that sometimes it works and sometimes it doesn't and there doesn't seem to be a distinction as to why. I've seen if one cell equals another one, and the same thing happens, sometimes they're equal, sometimes they're not. I hope you can help and if I wasn't clear, I can try to explain another way. Thanks!