# Thread: Convert Footage to Inches (Excel)

1. ## Convert Footage to Inches (Excel)

Good Afternoon All,

Hoping somenone can provide me with an easier solution than what I have to convert, say 4'06, to 54.

What I have right now is Assuming "A1" has 4'06 as a value:

I have to put the following formula in B2:
=LEFT(A1)**********this returns 4

In B3 I have:
Right (A1,2)********this returns 06

In C3:
=B1*12+C1********this returns 54

The following code works for converting the 54 to foot and inches: =INT(C3/12)&" Feet "&MOD(C3,12)&" inches" ***********However you need to know the total inches for this to work.....what I need is a formula or better process to determine the footage from the value in A1.

Hope this was clear and someone can provides some insight...Thanks in advance.

2. ## Re: Convert Footage to Inches (Excel)

Something like :

=(LEFT(A1,FIND("'",A1)-1)) & " Feet " & RIGHT(A1,LEN(A1)-FIND("'",A1)) &" Inches"

should help.

Andrew C

3. ## Re: Convert Footage to Inches (Excel)

Excel has no built in way to handle ft/inches
One "simple" way is to use a custom format:
"# ??/12"
then you can enter something like(no quotes): "4 6/12" and excel will convert to 4.5 but display 4 6/12. If you enter in " 54/12" it will also convert to "4 6/12" and keep 4.5 as the value.

What forms of "text" will A1 have (to be converted)
4'6" (text)
4'06 (text)
4.5 (number)
4 + 6/12' (text)
Etc
Will they ALWAYS have the foot mark(') ? You could FIND the foot mark and take the value of stuff to left and stuff to right.

Do you want the "result" to be a number (54 inches or 4.5 feet which can be used in calculations) or text (eg "4 foot - 6 inches" which can not calculate)?

Here is a website which has a funtion to convert, maybe it will give you some ideas:
http://www.mrexcel.com/tip012.shtml?cf0A52...e0B4OPW1G8tLdEz

Steve

4. ## Re: Convert Footage to Inches (Excel)

Thanks to all,

After a little dabbling with Andrew's suggestion, I was able to get the results I needed which was the total INCHES.....thanks for the suggestions and the web link.

Have a nice evening...or Day as the case may be where Andrew is from.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•