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🤔:

Convert feet and inches to inches In Excel 1

We have taken an example which includes a bunch of measurements that needs to be converted. So, let’s get started with the same🤓!

Convert feet and inches to inches In Excel 2

The first thing that we will do is to input the LEFT Function, which is as follows:

=LEFT(

The following formula requires text, [number characters] (which can be optional at times).

Convert feet and inches to inches In Excel 3

In the case of text, we will select the feet and inches data in hand, which is 4’ 5” (cell B3).

Convert feet and inches to inches In Excel 4

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🤷!

How to get the name from email address QUICKLY in excel?

The FIND Function is as follows:

=FIND(

The following formula requires find text, within text, [start number] (which can be optional at times)

Convert feet and inches to inches In Excel 5

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.

Convert feet and inches to inches In Excel 6

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).

Convert feet and inches to inches In Excel 7

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.

Convert feet and inches to inches In Excel 8

After closing the LEFT Function, we will multiply the whole thing with 12 (as shown in the image above).

Convert feet and inches to inches In Excel 9

And we will add 12 with the SUBSTITUTE Function (as shown in the image above).

The SUBSTITUTE Function is as follows:

=SUBSTITUTE(

The following formula requires text, old text, new text, [instance number] (which can be optional at times).

Convert feet and inches to inches In Excel 10

In the text, we will input the MID Function which is as follows:

=MID(

The following formula requires text, start number, number characters.

Convert feet and inches to inches In Excel 11

In the text of MID Function, you will enter the data in hand, i.e. cell B3 (4’ 5”).

Convert feet and inches to inches In Excel 12

Then in the start number, you will input the FIND Function which is as follows:

=FIND(

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.

Convert feet and inches to inches In Excel 13

Then in the FIND Function we will again specify apostrophe in quotation marks, as follows: “’”

Convert feet and inches to inches In Excel 14

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”.

Convert feet and inches to inches In Excel 15

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.

Convert feet and inches to inches In Excel 16

Then moving to the number characters, we will input the LEN Function which is as follows:

=LEN(

The following formula requires text.

Convert feet and inches to inches In Excel 17

The text will be the data in hand i.e. cell B3 (4’ 5”).

Convert feet and inches to inches In Excel 18

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).

Convert feet and inches to inches In Excel 19

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

Convert feet and inches to inches In Excel 20

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!!!💩)

Convert feet and inches to inches In Excel 21

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:

=LEFT(B3,FIND(“’”,B3)-1)*12+SUBSTITUTE(MID(B3,FIND(“’”,B3)+1,LEN(B3)),””””,””)

Convert feet and inches to inches In Excel 22

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.

Convert feet and inches to inches In Excel 23

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.

Convert feet and inches to inches In Excel 24

And there you go, your feet and inches converted into just inches.

Convert feet and inches to inches In Excel 25

So, it’s easy, isn’t it😅? (Ok, don’t kill me, I know it isn’t easy😜!)