Convert inches to feet and inches (indirect function).

So I have 5.8 ft in one column (a1) and in b1 I want the height converted to show 5' 9.6"
I think it's an indirect function?

Thanks!

I don't know why you think it is an INDIRECT function - that is used for a totally different purpose.

Assuming you have 5.8 ft in cell A5, you can use this in B5:

=INT(LEFT(A5,FIND(" ",A5)-1))&"' "&TEXT(MOD(LEFT(A5,FIND(" ",A5)-1),1)*12,"0.0")&CHAR(34)

Hope this helps.

Pete

I always get the offset, indirect and other text functions mixed up!
The data will have only 5.8 as the number with no units. The function you provided only works if you have a space after the units and then units.

Well, that is what you put in your first post. Are you saying that you just have the number 5.8 in the cell ?

Pete

I see that you are saying that. Use this simpler formula in B5 instead:

=INT(A5)&"' "&TEXT(MOD(A5,1)*12,"0.0")&CHAR(34)

Hope this helps.

Pete

That works sir...THANKS!

You're welcome - glad to help.

You can also show your appreciation by clicking on the "star" icon on the left hand side below any post that has helped you.

Pete