'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Convert Feet and Inches Fractions to Decimal Feet in Excel
Question details
The user needs to convert a text string representing feet, inches, and fractions into a pure decimal feet number using an Excel formula.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Converting architectural or engineering measurement data into decimal formats for mathematical calculations.
- Observed behavior
- Measurements are currently formatted as text strings (e.g., 1015' 3 1/4"), which cannot be used directly in calculations without conversion.
Ensure your measurement data follows a consistent text format with the standard single quote for feet and double quote for inches, separated by a space.
Use the LET and TEXTSPLIT Formula (Modern Excel)
This approach uses modern Excel functions to cleanly split the text string and calculate the decimal value.
If you are using Microsoft 365 or Excel 2021, you can use the TEXTSPLIT function to separate the feet from the inches, and the LET function to streamline the calculation.
Click on a blank cell next to your measurement data (for example, cell B1).
Type the formula: =LET(p,TEXTSPLIT(A1,"'"),INDEX(p,1)+SUBSTITUTE(INDEX(p,2),CHAR(34),"")/12) and press Enter.
Right-click the cell, select 'Format Cells', navigate to the 'Number' tab, and set the decimal places to 3.
Use Standard Text Functions (All Excel Versions)
If you are using an older version of Excel, you can use traditional text extraction formulas to achieve the same result.
Handle Complex Engineering Data with WPS Spreadsheet
WPS Spreadsheet makes it simple to manage, calculate, and format complex measurement data. It provides powerful data processing capabilities for all your architectural conversion needs.
- 1. Open your dataset: Launch WPS Spreadsheet and open the workbook containing your measurements.
- 2. Enter the formula: Select the target cell and paste the text extraction formula into the formula bar.
- 3. Adjust decimal precision: Press Enter, then use the 'Increase Decimal' button on the Home tab to format the result.
Frequently Asked Questions
Why am I getting a #NAME? error when using TEXTSPLIT?
The TEXTSPLIT function is only available in Microsoft 365 and Excel 2021 or newer. If you are using an older version, Excel will not recognize the function. You must use standard text functions like LEFT, MID, and FIND instead.
How does the formula handle fractions like 1/4 inch?
Once the formula removes the inch symbol and extracts the remaining text string (e.g., ' 3 1/4'), it divides it by 12. During this math operation, Excel's calculation engine automatically interprets the fractional text as a numeric value.
How can I format all my converted numbers to three decimal places at once?
Highlight all the cells containing your results, press Ctrl+1 to open the Format Cells dialog, select 'Number' from the Category list, and change the 'Decimal places' box to 3.
