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...