How to Add Paired Numbers Such as 1/1 and 56/198 in WPS Office Spreadsheets
Question details
The user needs to add paired values stored as text strings, such as 1/1 and 56/198, by splitting each value at the slash and summing numerators and denominators separately.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has paired numeric text strings in worksheet cells and needs a formula to calculate combined totals without manually splitting every entry.
- Observed behavior
- Values such as 1/1 and 56/198 are treated as text, so ordinary addition does not return the desired paired total and may evaluate incorrectly.
Open your worksheet in WPS Office Spreadsheets and identify the cells that contain slash-separated values. Make sure the cells are formatted as Text or entered with a leading apostrophe so values like 1/1 are not converted to dates.
Use TEXTSPLIT and TEXTJOIN to Add Paired Values
Best for a single-cell formula when you already have two slash-separated text values such as A1 and B1.
Paired values such as 1/1 and 56/198 are text strings, not ordinary numbers. TEXTSPLIT separates the numerator and denominator at the slash, VALUE converts them to numbers, and TEXTJOIN combines the summed parts back into the same paired format.
Click the cell where you want the summed paired value to appear, for example C1.
Type =TEXTJOIN("/",TRUE,VALUE(TEXTSPLIT(A1,"/"))+VALUE(TEXTSPLIT(B1,"/"))) and replace A1 and B1 with the cells that contain your values.
Press Enter. For A1 containing 1/1 and B1 containing 56/198, the result cell displays 57/199.
Store Numerators and Denominators in Separate Columns
Better for ongoing data entry because each part stays numeric and can be summed with standard formulas without text parsing.
Add Paired Text Numbers in WPS Office Spreadsheets
Use WPS Office Spreadsheets to split, add, and recombine paired values such as 1/1 and 56/198 with Excel-compatible formulas, or switch to separate columns for simpler totals.
- 1. Open your workbook in WPS Office Spreadsheets: Launch WPS Office, click Spreadsheets, and open the file that contains the paired values.
- 2. Select the result cell: Click an empty cell, such as C1, where you want the combined paired result.
- 3. Enter the paired-number formula: Type =TEXTJOIN("/",TRUE,VALUE(TEXTSPLIT(A1,"/"))+VALUE(TEXTSPLIT(B1,"/"))) and press Enter.
- 4. Adjust the cell references: Replace A1 and B1 with your actual source cells and verify that the result shows the summed numerator and denominator.
Frequently Asked Questions
Why does Excel or WPS Office turn 1/1 into a date when I type it?
Entering 1/1 in a number-format cell may be interpreted as January 1. Format the cells as Text before entry, or type an apostrophe before the value, such as '1/1, to keep it as text.
Can I add more than two paired values at once?
Yes. Extend the recommended formula by adding more VALUE(TEXTSPLIT(...)) parts. For example, use =TEXTJOIN("/",TRUE,VALUE(TEXTSPLIT(A1,"/"))+VALUE(TEXTSPLIT(B1,"/"))+VALUE(TEXTSPLIT(C1,"/"))).
What if TEXTSPLIT is not available in my WPS Office version?
Use separate numerator and denominator columns with SUM, or split the slash-separated values with Data > Text to Columns into helper columns, then add the helper columns.
How do I keep the result as text instead of a number?
TEXTJOIN returns a text string, so the result such as 57/199 remains text and will not be interpreted as a date or a division.
Is it better to store paired numbers in separate columns?
Yes. Separate numeric columns are more reliable for sorting, filtering, summing, and reporting than slash-separated text strings.
