How to convert inches to feet & inches in ms excel?

How to convert inches to feet & inches in ms excel?
Formula:
=INT(B3/12)&"' "&ROUND(MOD(B3,12),1)&""""
Music Credits:
Music: no copy writemusic
Musician:
.
.
.
#msexcel #excel #microsoftexcel #microsoft #exceltips #exceltraining #office #exceltricks #learnexcel #spreadsheet #excelfunctions #data #excelshortcuts #excelformulas #excelprofessional #microsoftoffice #excelskills #business #advancedexcel #excelspreadsheets #msoffice #spreadsheets #msword #accounting #vlookup #msexceltraining #intermediateexcel #exceltestforjobinterview #exceltutorials #

[@NealHartsChannel]

This is great! What would I add to the formula so that blank cells return blank? With the current formula it returns 0' 0"

[@Ambuj-Thakur]

Can you elaborate

[@Ambuj-Thakur]

Please check video

[@ramkishankumawat8834]

Bhaii agar isi ko reverse formula lagana ho jaise 5'6" ko 66 karna ho to kaise kare. Please help

[@Ambuj-Thakur]

As we all know, one foot equals twelve inches. So, if we want to convert n feet to inches, then the value will be n * feet. As a result, we can use the formula =A2*12.

[@Ambuj-Thakur]

The formulas are used to convert feet to metres and miles.
Meters : =Convert(A2, "ft", "m")
Nautica Miles : = Convert(A2, "ft", "Nmi")
Statute miles : =Convert(A2, "ft", "mi")

[@yadavthapa4992]

How to convert feet (5.03ft) into feet and inches (5 ft 3.6 Inc)

[@Ambuj-Thakur]

All ready explain fit and inch use convert function