# Formula Help

#### slivesay

##### Board Regular
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!

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Fluff

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

Replies
5
Views
307
Replies
3
Views
890
Replies
7
Views
190
Replies
1
Views
244
Replies
0
Views
167

1,195,670
Messages
6,011,074
Members
441,580
Latest member
BornholmerBjarne

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back