Formula Help

[slivesay]

I need a formula that will turn (example )10'0" into inches - does not have to show the inches ", but if 10" is in cell then it will show 10. Once this is complete I have a formula that will look at a range and determine if a certain text is there and will add 3" to the cell. Lastly I need to have a formula to have the inches " to display. All this can be in different cells as long as they point to each other.

Here is what I have so far to convert from ft to in, but I am willing to change the formula.
=LEFT(D11, FIND("'", D11)-1)*12+MID(D11, FIND("'",D11)+1, LEN(D11)-FIND("'",D11)-1)

Here is finding the text and adding 3".
=IF(COUNTIF(B11:B123,"*"&T11&"*"),U11+3)

Thank you so much for any assistance. I truly appreciate it!

 

[Fluff]

To show the inches " you can simply format the cell eg #,##0''
where the '' are two single apostrophes