Problems converting fraction as a text cell to a decimal

Building on your work so far, in cell S2, use:

Please Login or Register  to view this content.

Cheers,

I would tend towards using the VALUE() function, recognizing that Excel can automatically detect fractions/mixed numbers as long as they are in the form x xx/xx. If I can coax the text to be in that format, then Excel will convert to number. I tried something like

=IF( -- outer IF() function
OR( -- two cases to test: mixed number or integer inch
LEN(C2)=2, -- to capture the integer inch cases Excel can automatically convert to number
MID(C2,2,1)=" "), -- to capture the mixed number cases Excel can automatically convert to number
VALUE(LEFT(C2,LEN(C2)-1)), -- extract the mixed number/integer without the quote and convert to number
VALUE(CONCATENATE("0 ",LEFT(C2,LEN(C2)-1)))) -- Extract the fraction without quote, tack "0 " onto the front of it, and convert to a number.

It is certainly not the only way to do it, but that's probably how I would do it (without changing the input data).