I have something like "W 110-96" and i need to turn it into 110 in one column and 96 in another column. Tried using combination of Right/Left and some If statements but just haven't come up with anything that works. For example if i use right 2 it will take 96 but if the score is 3 digits then it will cut off part of the number. Problems like that. I'm googling it now just wanted to see if someone knows before i start trying things.
