Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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.

    If you want custom conversion, we need more info:
    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. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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