I am trying to extract numbers, some of which are fractions, from a text string to use in calculating the weight of the material in a list.
Example from cell D14: Bar 4x1/4
I was able to extract the "4" with =VALUE(MID(D14,SEARCH(" ",D14,1)+1,(SEARCH("X",D14,1))-(SEARCH(" ",D14,1)+1))) but I...