Convert Feet and Inches from Another Worksheet in One WPS Office Spreadsheets Formula
Question details
The user needs to convert a feet-and-inches value stored on another worksheet into decimal feet using a single Excel-compatible formula so the result can be reused in later multiplication or summation calculations.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has a feet-and-inches text value on one worksheet and needs to reference it from another worksheet within a conversion formula.
- Observed behavior
- The desired result is a decimal-foot value that can be used directly in later multiplication or summation formulas.
Confirm the worksheet name and source cell you need to reference, such as 'FO-PO'!F27, and verify that the feet-and-inches value uses a hyphen separator followed by a double quote for inches before applying the formula.
Use a Single Cross-Sheet Formula to Convert Feet and Inches to Decimal Feet
Use this solution when the feet-and-inches text is on another worksheet and you want the numeric decimal-foot result in one formula without helper columns.
The formula reads the feet portion before the hyphen, removes the hyphen and inch symbol from the remaining text, and divides the inches by 12. The returned value is numeric, so it can be referenced directly by further multiplication or SUM formulas.
Click the cell in WPS Office Spreadsheets where the decimal-feet result should appear.
Type =LEFT('FO-PO'!F27,FIND("-",'FO-PO'!F27)-2)+SUBSTITUTE(REPLACE('FO-PO'!F27,1,FIND("-",'FO-PO'!F27),""),CHAR(34),"")/12 and press Enter.
Replace every 'FO-PO'!F27 reference with your actual worksheet name and source cell, for example 'Measurements'!B10. Keep single quotes around sheet names that contain spaces or special characters.
Apply Feet-and-Inches Conversion with Cross-Sheet References in WPS Office Spreadsheets
Open your workbook in WPS Office Spreadsheets, enter the combined cross-sheet formula, and WPS returns a numeric decimal-foot value you can reuse in later multiplication or summation. WPS Office Spreadsheets preserves Excel formula behavior while remaining free, lightweight, and compatible with Microsoft Excel files.
- 1. Open the workbook in WPS Office: Launch WPS Office and open the Excel workbook that contains the source worksheet and the destination worksheet.
- 2. Select the destination cell: Click the cell where the decimal-feet result should be displayed.
- 3. Enter the cross-sheet conversion formula: Type =LEFT('FO-PO'!F27,FIND("-",'FO-PO'!F27)-2)+SUBSTITUTE(REPLACE('FO-PO'!F27,1,FIND("-",'FO-PO'!F27),""),CHAR(34),"")/12 and press Enter.
- 4. Use the numeric result in later calculations: Click the result cell and reference it in subsequent multiplication or SUM formulas to continue your calculation.
Frequently Asked Questions
What does this formula do?
It reads a feet-and-inches text value from another worksheet, extracts the feet before the hyphen, converts the inches after the hyphen to a fraction of a foot, and returns decimal feet.
How do I edit the formula for a different worksheet or cell?
Replace every occurrence of 'FO-PO'!F27 with your own reference, for example 'Checklist'!C12. Keep apostrophes around sheet names that contain spaces or special characters.
Can I multiply or sum the converted result?
Yes. The formula returns a number, so you can use the result cell in formulas such as =A1*2 or =SUM(A1:A10) without extra conversion.
What if my inches value does not use a double quote mark?
The CHAR(34) part removes the standard inch symbol. If your data uses a different annotation, replace CHAR(34) with the actual character or character code used in your worksheet.
