Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Get nth match with INDEX / MATCH in Excel
  • How to get address of last cell in range in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to use Excel COLUMN Function
  • How to create dynamic named range with OFFSET in Excel

Data Analysis Examples

  • Chart Axes in Excel
  • Understanding Pivot Tables in Excel
  • Get column name from index in Excel Table
  • How To Filter Data in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation don’t exceed total
  • Excel Data validation must contain specific text
  • Excel Data validation specific characters only

Convert inches to feet and inches in Excel

by

To convert a measurement in inches to inches and feet (i.e. 53 to 4′ 5″) you can use a formula based on the INT and MOD functions. See illustration below:

Formula

=INT(A1/12)&"' "&MOD(A1)&""""

Explanation

In the example shown, the formula in D5 is:

=INT(B5/12)&"' "&MOD(B5,12)&""""

How this formula works

This formula converts a numeric value in inches to text representing the same measurement in inches and feet. To get the value for feet, the INT function is used like this:

=INT(B5/12)&"' "

Inside INT, the value in B5 is divided by 12 and INT simply returns the integer portion of the result, discarding any decimal remainder. The result is then concatenated to a string with a single quote and space character.

Worked Example:   How to calculate most recent day of week in Excel

To get a value for inches, the MOD function is used like this:

MOD(B5,12)&""""

where number comes from B5 and the divisor is 12. Configured in this way, MOD returns the remainder after division. The result is concatenated to two sets of double quotes. The outer pair indicates text, and inner pair is needed for Excel to output a single double quote.

Worked Example:   Highlight every other row in Excel

Finally, the INT code and MOD code are concatenated together and Excel returns the final text value.

Worked Example:   Use of INT and TRUNC function in Excel

With complete labels

To output a value like “8 feet 4 inches”, you adapt the formula like this:

=INT(B5/12)&" feet "&MOD(B5,12)&" inches"

Post navigation

Previous Post:

Convert feet and inches to inches in Excel

Next Post:

Calculate a ratio from two numbers in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to display conditional message with REPT function in Excel
  • How to pad text to match equal length in Excel
  • How to extract last two words from text string in Excel
  • Add line break based on OS in Excel
  • UNICHAR function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate next anniversary date or birthday in Excel
  • How to calculate nth day of week in month in Excel
  • How to get year from date in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • How to get Weekdays, Working days between Two Dates in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
  • Tax rate calculation with fixed base in Excel
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • VDB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles