How to Convert Inches to FT in Excel Formula

Transcript

00:00hi everyone in this video i will guide you how you can convert inches to feet and back

00:06feet to inches in excel with a formula it's pretty simple and easy let's get started first you need

00:13to select the cell where you want to place the formula i am selecting this cell you need to

00:21put the is equal to and use the convert function open bracket and select the cell comma and then

00:34space and then double quote and you are now converting inches to feet so for inches you need

00:44to type i n double quote comma and again double quote and now you need to put ft for feet double

00:55quote and close the packet hit enter and here you can see that it is easily converted the 24 inches

01:07is equal to 2 feet and 30 inches equal to 2.50 so and you can see that now you can back to the

01:18feet two inches so how you can reverse the formula is equal to convert bracket open select the cell

01:29comma space double quote now you are converting feet to inches now you need to put

01:36ft double quote comma double quote in inches double quote and close the bracket hit enter and now you can

01:48see that the formula has been converted feet to inches and the values are same so with this formula you can

01:59easily convert values and make your life easy if you think this video is helpful

02:06and you have learned something new please support my channel and don't forget to like share and subscribe

02:12thank you very much