If you have a cell with the values of 12-9 which reflects a win/loss record. How do you extract the value 12 and the the value 9 without including the dash. Remember at the beginning of the season you may have a record of 1-1 and then when the season progresses the values may go to 10-10. How does Excel automatically recognize the vales going to 2 digits.
I am looking for a formula such as this
=VALUE(LEFT(ARI!B44,1))
=Mid(A2,Find(“-“,A2)+1,2)
The problem with these you have to change the value from 1 to 2 at the end of formula 1 manually. I want the formula to recognize if the value has a double digit such as 10 vs. a single digit number such a 9.
Thanks
I am looking for a formula such as this
=VALUE(LEFT(ARI!B44,1))
=Mid(A2,Find(“-“,A2)+1,2)
The problem with these you have to change the value from 1 to 2 at the end of formula 1 manually. I want the formula to recognize if the value has a double digit such as 10 vs. a single digit number such a 9.
Thanks