Skip to playerSkip to main content
  • 3 months ago
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
Be the first to comment
Add your comment

Recommended