If you are looking for a way where you could convert feet and inches into inches through excel, you have come up in the right place. You see, when you are dealing with loads of data’s, you cannot just open google again and again to convert things for you, because it becomes a chaos then.
So, to convert the feet and inches into inches, here’s what you can do🤔:
We have taken an example which includes a bunch of measurements that needs to be converted. So, let’s get started with the same🤓!
The first thing that we will do is to input the LEFT Function, which is as follows:
The following formula requires text, [number characters] (which can be optional at times).
In the case of text, we will select the feet and inches data in hand, which is 4’ 5” (cell B3).
Then in the number characters we will input the FIND Function, this is because we need to convert something into something, so we cannot just give a number to it🤷!
The FIND Function is as follows:
The following formula requires find text, within text, [start number] (which can be optional at times)
Then in the find text, we will input the following: “’” This is written due to a reason: first, the quotation marks are used because we are adding specifications in the formula, second as feet and inches are written as 4’ 5”. So, the first thing to find for conversion is the apostrophe i.e. ‘
Then we will move to within text, as we need to look for the apostrophe in the cell B3 i.e. 4’ 5”, so we will select the same (as shown in the image above).
Then we will close the FIND Formula and subtract the same with 1 and then we will close the LEFT Formula.
Please note: you cannot put a comma i.e. you cannot separate -1 with the FIND Function, as -1 is also a part of number characters of the LEFT Function.
After closing the LEFT Function, we will multiply the whole thing with 12 (as shown in the image above).
And we will add 12 with the SUBSTITUTE Function (as shown in the image above).
The SUBSTITUTE Function is as follows:
The following formula requires text, old text, new text, [instance number] (which can be optional at times).
In the text, we will input the MID Function which is as follows:
The following formula requires text, start number, number characters.
In the text of MID Function, you will enter the data in hand, i.e. cell B3 (4’ 5”).
Then in the start number, you will input the FIND Function which is as follows:
The following formula requires find text, within text, [start number] (which can be optional, at times)
You may find this whole thing confusing😵, as after every function, a new function is being entered. But once you try it by yourself, you’ll find it easy🤓, plus you only have to input the same once, then all you have to do is drag down till its required😎.
Also, for those who are getting confused by looking at the formula, stick to the formula bar above, you will find it more convenient.
Then in the FIND Function we will again specify apostrophe in quotation marks, as follows: “’”
And in the within text, we will select the data in hand i.e. cell B3 as we need to find the apostrophe from 4’ 5”.
After inputting the within text i.e. cell B3, we will close the FIND Formula and get back to the MID Formula. As the FIND Function was a part of start number in the MID Function, we will continue in the same by adding 1 to it.
Then moving to the number characters, we will input the LEN Function which is as follows:
The following formula requires text.
The text will be the data in hand i.e. cell B3 (4’ 5”).
After inputting the text in the LEN Function, we will close the same, and after it we will also close the MID Function.
If you are getting confused, you may check the colors of the brackets, ad resolve your query (given in the image above).
Now that we have closed the MID Function, we are back in the SUBSTITUTE Function, so as we are done with the text, we will move on to the old text which will be “”””.
Please note that the “ “ one pair of quotation marks are inputted because we are adding a specification to the formula and the other pair of quotation marks which are inside the quotation marks are specifying the following – 4’ 5”
Then we will move to the new text, in which we will leave the quotation marks as it is, this means that we are leaving it blank. (adding nothing but NIL BATA SANATA!!!💩)
Jokes aside, now all we have to do is close the SUBSTITUTE Function and our work is done.
So, till now, our overall formula is as follows:
Now all we have to do is press enter and BAAAAMMM💣!!! (you can pretty much get the feel of it!😵)
Your answer is 53. This means that when we convert 4 feet 5 inches, into inches, it becomes 53 inches in total.
Now all we have to do is drag down😏 the formula till its required because who’s gonna go to that façade over and over again.
And there you go, your feet and inches converted into just inches.
So, it’s easy, isn’t it😅? (Ok, don’t kill me, I know it isn’t easy😜!)