Function Problems

WPS Spreadsheet: Combine Text from Two Excel Cells with a Formula

Huma Ashraf Ch Nov 12, 2026 868 views

Question details

The user needs to combine values from two spreadsheet cells with fixed text in one formula.

WPS Spreadsheet: Combine Text from Two Excel Cells with a Formula

Product: WPS Spreadsheet
Device & OS: not provided
Scenario: Create a sentence such as “2 off 12 m length” by combining the values in cells R84 and AC84 with connecting words and units.
Observed behavior: The current formula does not include one of the required cell values, so the resulting sentence is incomplete.

Before you start

Identify the two source cells and the cell where the combined sentence should appear. Check whether the source cells contain numbers, text, or blanks so the formula can be adjusted if needed.

Solution 1Recommended

Use the ampersand operator to combine both cells and text

Use this solution when you need a simple formula that joins two cell references with fixed words, spaces, and units.

In WPS Spreadsheet, the ampersand operator (&) joins cell values and text into one result. Text that should appear literally must be enclosed in quotation marks, including spaces and units.

Select the result cell

Open the worksheet in WPS Spreadsheet and click the cell where the completed sentence should appear.

Enter the concatenation formula

Type =R84&" off "&AC84&" m length" in the selected cell, then press Enter.

Check the combined result

Confirm that the cell displays the value from R84, the text “ off ”, the value from AC84, and “ m length” in one sentence.

Adjust the references if needed

Replace R84 or AC84 with the actual source cell references if your values are located elsewhere.

Example result: If R84 contains 2 and AC84 contains 12, the formula returns “2 off 12 m length”.

Solution 2

Combine cells with CONCAT or TEXTJOIN

Use a function-based approach when you need to join several cells or manage separators more conveniently.

Combine Excel Cell Values Easily in WPS Spreadsheet

WPS Spreadsheet lets you join cell values and custom text with the ampersand operator, CONCAT, or TEXTJOIN. Build complete sentences, preserve familiar spreadsheet formulas, and work directly with Excel-compatible files.

1. Open the workbook: Launch WPS Office, choose Spreadsheet, and open the Excel workbook containing the source cells.
2. Choose the output cell: Click the cell where the combined text should appear.
3. Enter the formula: Type =R84&" off "&AC84&" m length" in the formula bar or directly in the cell.
4. Confirm and edit: Press Enter, review the result, and change the cell references or quoted text if necessary.

Create complete sentences from multiple cell values with a single formulaUse familiar ampersand, CONCAT, and TEXTJOIN functions in a lightweight spreadsheet editorOpen, edit, and save Microsoft Excel XLS and XLSX files with broad format compatibilityAdd fixed words, spaces, units, and punctuation without manually retyping cell values

microsoft office alternative - wps office

Frequently Asked Questions

What formula combines two cells with words in WPS Spreadsheet?

Use the ampersand operator, for example =R84&" off "&AC84&" m length". It joins both cell values with the text between the quotation marks.

Why must spaces be included inside quotation marks?

A formula does not automatically add spaces between joined items. Include spaces inside text strings, such as " off ", to keep the result readable.

How do I change the formula for different cells?

Replace R84 and AC84 with the references of your source cells, while keeping the ampersands and quoted text in the required order.

Can I combine text when one source cell is blank?

Yes. The formula still returns the fixed text and the nonblank value, but it may leave extra words or spaces. Use TEXTJOIN with TRUE when you need to ignore empty cells.

Excel & Data Problems