Remove Blanc Space, parse text, convert text to measurement

Hello,
I have a cell which holds a Feet-Inch measurement such as 60’-10”.
I am trying to come up with a formula to read the value from this cell and do the conversion to inches, like =60*12+10
There are some complicating factors though:
- If the cell has a value like 60’-10 Ύ”, than, I want to ignore the Ύ” or whatever fraction follows the round inch number.
- The Feet value could be one or two digit (never more than two digits), same the Inch value (it could be 6’-1”; 6’-10”; 60’-1” and so on… any combination of these).
- Sometimes there might me spaces before the first digit or after the last digit or anywhere between, like: _60_’_10”_ (the “_” is a space, not actual “_”).
Complicated.. (For me)
Could somebody advice?
Thank you

What other fractions are you likely to encounter? Please list them.

From what you have said above you can get the feet to inches like this:

=LEFT(A1,FIND("’",A1)-1)*12

(NOTE that the apostrophe is not the one from the keyboard, so just copy this into the formula bar), and you can extract the inches like this:

=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("’",A1)+1,FIND("”",A1)-FIND("’",A1)-1),"Ύ",""),"-","")+0

So you can have this combined formula in B1:

=LEFT(A1,FIND("’",A1)-1)*12+SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("’",A1)+1,FIND("”",A1)-FIND("’",A1)-1),"Ύ",""),"-","")

and it will cope with all the examples you have posted. (NOTE that the double quotes in your examples, the inches sign, is not the normal quotes character either).

Hope this helps.

Pete

Thank you both FDibbins and Pete !No need to tweak, it works perfect !