ExcelBanter - how to convert 112" to 9'4" with a formula in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to convert 112" to 9'4" with a formula in Excel (https://www.excelbanter.com/excel-worksheet-functions/197300-how-convert-112-94-formula-excel.html)

ate3sixty

how to convert 112" to 9'4" with a formula in Excel

Pete_UK

how to convert 112" to 9'4" with a formula in Excel

Assuming you have 112" in A1, put this formula in B1:

=INT(LEFT(A1,LEN(A1)-1)/12)&"'"&MOD(LEFT(A1,LEN(A1)-1),12)&CHAR(34)

Hope this helps.

Pete

On Aug 1, 10:22*pm, ate3sixty
wrote:

All times are GMT +1. The time now is 12:48 PM.