1. B

    Convert or split then combine numbers from cell

    Hello! I have plenty of cells with dimensions in the following format: 100x50cm I am looking for an efficient way to convert those to inches, so the result should look like 39x20" inches. I am looking for a formula that could convert it directly or indirectly, perhaps by first splitting the...
  2. J

    Help: flexible handling of units of measure (inches, cm, meters)

    Hey all, I have a formula that splits a persons height from its unit of measure (in,cm,m) it’s intention is to be flexible to quickly capture the metric from different data sources. When I started working on if I used IFS but some of our data entry people are on older versions of Excel. Is there...
  3. A

    First time OpenSolver user

    Hello, I have 475 feet of pipe that I need to cut to the following sizes. Each pipe is 40 feet long (480 Inches) so I want to optimize the cuts in order to stay as close as possible to 12 pipes. <colgroup><col><col></colgroup><tbody> Inches QTY 8.00 20 10.00 6 12.00 8 27.00 2 32.00 6...
  4. S

    change column headings to inches

    Hi i'm using 365 I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches. Was I dreaming? I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right. mike
  5. S

    feet and inches and fractions

    Hi folks, I have been struggling with converting decimal feet inches and fractions and I am at a stand still. I have managed to convert to metres, and inches, but I am struggling to get to feet, inches and fractions. I am having 3 issues. 1) it is displayed something complex like 4' 3 51/71" (I...
  6. S

    Convert and display feet, inches and fractions in excel

    Hi folks I understand there are several forums on this or similar but I am having a nightmare with it. I have values displayed in decimal feet which I have converted to metres with no issues, but I now have to display this in inches and fractions as well as feet, inches and fractions. I have...
  7. N

    Formula not working properly

    Would you please provide some feedback on the following formula? It is supposed to be converting the data in cell CSV!AQ3 from feet and inches to decimal inches and doesn't seem to be doing it properly. On my spreadsheet it's showing the result is 4.375 when (I think) it should be 19.625. The...
  8. R

    Calculation based on existing column, don't know range

    Need help with the following: I have a height and width column in pixel count. I convert the pixels to inches without a problem. How do I figure out the last row in the column. They amount of rows will change every time I pull my data. In other words, how can I create my calculation for each...
  9. N

    Converting Fractional inches and feet-inches to decimal inches

    I've scoured the archives looking for a way to convert fractional inches or feet-inches into decimal inches and couldn't find a solution. I have column CO looking at column CN as a reference to convert the entry from inches or feet-inches (the data varies) to decimal inches and can't get it to...
  10. R

    Excel: Formulas for feet and inches

    I am trying to combine 2 cells in excel. I have feet in column Hand inches(fraction form) in column I. I want to combine these two cells in column M and have it display feet and inches in fraction form. *I do not want to round. I have tried to use this formula that i found on the web but it...
  11. M

    Two-way lookup with INDEX and MATCH return closest match

    I'm working on a spreadsheet and have run into a issue using Two-way lookup with INDEX and MATCH. If the value is not in the table, I need excel to use the next highest value. Below is the formula I'm using...
  12. C

    Is it possible to convert a decimal number to feet and inches in a single cell?

    Is it possible to convert a decimal number to feet and inches in a single cell? I have a formula that outputs feet and inches as a decimal number and I would like to convert it to show feet and inches with the appropriate symbols. Example: 37.74 converted to 37' 8 5/16" To add another layer...
  13. F

    Is there an easy way to sort feet and inches?

    I'm trying to figure out how to easily sort feet and inches. Let's say I have a column with only feet.. IE: 34' 355' 154' 1503' 14' 6" 10' 7" 50' How could I sort this? I want to go greatest to least, and least to greatest. However, I'm having a hard time figuring this one out.. :( Any...
  14. JenniferMurphy

    UDF to convert a value to feet & inches

    I was able to find several solutions for converting a value to feet and inches where the inches are expressed as an integer plus a fraction. I couldn't find one that expressed the inches as a floating point number (n.nnn..) with the ability to specify the number of decimal points. So I wrote one...
  15. J

    Calculating position in inches from row height and number of rows not producing correct result

    All rows have a height of 15 points There are 72 points per inch Row 303 will have a position in points of (303*15) 4545 Row 303 will have a position in inches of (4545/72) of 63.125 One of my machines produces this result. On another machine the position in inches is 62.62 (using top in crop...
  16. S


    Hi everyone! I'm new to this forum so i'm hoping you guys can help me out. I'm trying to make a form that will be able to convert a measurement that is in carpenters form to a normal FT'In' Fraction Format. Ex. 9'6 1/2" is 09-06-08 the front 09-XX-XX stands for Ft, XX-06-XX stands for In...
  17. S

    unsquishing comment boxes for individual cells...

    I have code that standardizes all comment boxes but is it possible to isolate this for one cell? The reason I'd like this is because boxes are getting squished flat or distorted when moved around even if "locked" This is what I have: Sub Comments_Format() Dim cmt As Comment For Each...
  18. F

    Looking to build a graph from a small table. Curious if what I'm looking to do is possible.

    Imagine you have a very long roll of material, (Rolled up like a big spool) and out of that material, you cut sections of material out of it. For an example, we're dealing with a 72" wide piece that's 1000' Feet long. If you were to never cut anything from it, and look at it as if it was...
  19. K

    VBA Code To Parse and Evaluate Various Feet and Inch Notations For Peer Review

    I needed a function to convert feet and inches into a decimal number (eg 5' 10 1/2" => 60.5 (inches)). I found various excel formulas and UDF while googling around but either found them to limiting or error prone. I've cooked up the following RegExp based UDF to evaluate feet & inch strings and...
  20. H

    Adding Feet and Inches

    I am looking of for a simple worksheet to add feet and inches. Ie: column A has feet and column B has inches. Row 10 (?) would give you the result with feet in A and inches in B. I can get the result in feet and inches in decimal format in the same cell, but now in separate cells.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back