Text Fraction to formula MK2

I have a spreadsheet with text based fraction values. I would like to convert these fractions into decimals in an adjacent column. I asked a similar question the other day, but I'm still having issues.
Basically, I am wondering if there is an easy way to convert 1/8 in B2 to =1/8 in B3.

The first rows of my text column looks like this.

2
1-1/4
1/8
9/32

where 1-1/4 represents 1+(1/4)

As you can see, there are a few different styles of values. Any ideas?

What was wrong with the suggestion from MrShorty?
https://www.excelforum.com/excel-gen...al-values.html

(and you really should have continued on that thread, but we will let it slide this time )

63's is similar to mine in your other thread...

Try this, and format as Fraction...
=LEFT(B2,FIND("/",B2)-1)/MID(B2,FIND("/",B2)+1,99)

Link to earlier thread: https://www.excelforum.com/excel-gen...al-values.html

I would still be inclined to use the VALUE() function, you just need to get the text into a format like "a b/c", or otherwise identify the different forms the text can take. (I will mention that, if I had any control over data entry, I would force the data entry into a form that is easier to work with). As I explained in the other thread, the previous solution assumed that all entries were "b/c" entries and that there would never be mixed number entries. Now we see that mixed numbers are possible. Before getting too far into this, are these representative of all possible entries, or are there other considerations? Does a hyphen "-" always separate mixed numbers, or can other characters be used there?

With the 4 example values, something like this should work:
1) Use a SUBSTITUTE() function to get rid of the hyphen and replace it with a space SUBSTITUTE(B2,"-"," ")
2) Test if Excel wants to convert the value into a date, and act accordingly using an IF() function IF(VALUE(SUBSTITUTE(B2,"-"," "))>400,"0 "&B2,SUBSTITUTE(B2,"-"," ")). The 400 is just a value larger than anything you ever expect to get, that will also be smaller than any date serial number you may get.
3) Nest that inside of a VALUE() function. =VALUE(IF(VALUE(SUBSTITUTE(B2,"-"," "))>400,"0 "&B2,SUBSTITUTE(B2,"-"," ")))

Assuming I got all the parentheses matched up right, that works for the four examples you give. Will that work for you?