Feet and Inches

Hi,
I need to convert inches to feet and inches in this format:
88 1/2 = 7' 4-1/2"
...so that if 88 1/2 is in cell A1, cell B1 will show 7' 4-1/2".
The exact syntax of B1 must be as shown.
Thanks

I couldnt get the syntax to match your request exactly. Hopefully, someone else can expound.

If your inches are in A1, enter this formula into B!:

=INT(A1/12)&"' "&MOD(A1,12)&""""

Possibly amend BigBas' suggestion to

=INT(A1/12)&"' "&TEXT(MOD(A1,12),"0 #/#")&""""

Thx, daddy. I assumed someone would fix it using custom number formatting (which I am still not to great at).

O.K.
...Works Great!!! Thanks so much- what a neat group.
Ya'll (<I'm from Arkansas) saved the day.

This may sound crazy but I have the exact *opposite* problem...I have a measurement typed in text (for example 6-3 for 6 foot three inches) and need something that takes this text string and converts it to a number in inches (in this case 75 inches). Any help?

Originally Posted by Bryan Hessey

Hi,

=1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2))

will do that, the 1* I added solely because my A1 was 'Text' format and I didn't want the answer as text.

hth
---

EXCELLENT! Thanks so much!