Function Problems

WPS Spreadsheets: Concatenate Two Cells into a Third Cell

Huma Ashraf Ch Nov 12, 2026 869 views

Question details

The user needs to combine the contents of cells G9 and I9 in cell AA9, optionally placing a separator between the values.

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: A worksheet contains values in G9 and I9 that must be joined into a single result in AA9.
Observed behavior: The desired combined value has not yet been created in AA9.

Before you start

Confirm that G9 and I9 contain the values you want to combine, then select cell AA9 as the destination. Decide whether the result should include a separator such as a space.

Solution 1Recommended

Join G9 and I9 with the ampersand operator

Use this simple formula when you want direct control over the separator between the two cell values.

Select the destination cell

Open the worksheet and click cell AA9.

Enter the concatenation formula

Type =G9&" "&I9 into the formula bar or directly into AA9, then press Enter. The quoted space inserts a space between the two values.

Remove the separator if needed

To combine the values without any separator, replace the formula with =G9&I9 and press Enter.

Example result: If G9 contains John and I9 contains Smith, =G9&" "&I9 returns John Smith in AA9.

Solution 2

Use TEXTJOIN to combine cells and ignore blanks

Choose TEXTJOIN when you want a separator and need empty source cells to be skipped automatically.

Solution 3

Use CONCATENATE for a legacy-compatible formula

Use CONCATENATE when working with an older spreadsheet formula style or an existing workbook that already uses it.

Combine Spreadsheet Cells Easily in WPS Spreadsheets

WPS Spreadsheets lets you combine cell contents with the ampersand operator, TEXTJOIN, or CONCATENATE. Enter the formula in a destination cell such as AA9 and adjust the separator to match your worksheet.

1. Open your workbook: Launch WPS Office, choose Spreadsheets, and open the workbook containing cells G9 and I9.
2. Select the output cell: Click cell AA9, or select another cell where you want the combined result to appear.
3. Enter a formula: Type =G9&" "&I9 into the formula bar and press Enter to combine the values with a space.
4. Adjust the result: Use =G9&I9 for no separator or =TEXTJOIN(" ",TRUE,G9,I9) to ignore blank source cells.

Quickly combine values with spaces or other separatorsTEXTJOIN can ignore empty cells when building resultsSupports Microsoft Excel .xlsx and .xls workbook formatsFamiliar spreadsheet formulas make migration straightforward

Frequently Asked Questions

What formula combines G9 and I9 in AA9 with a space?

Select AA9 and enter =G9&" "&I9, then press Enter. The quoted space appears between the contents of G9 and I9.

How can I concatenate the cells without a separator?

In AA9, enter =G9&I9. This joins the two values directly without adding a space or other character.

Which WPS Spreadsheets formula ignores blank cells?

Use =TEXTJOIN(" ",TRUE,G9,I9). The TRUE argument tells TEXTJOIN to skip empty cells while using a space as the separator.

Can I use CONCATENATE in WPS Spreadsheets?

Yes. Enter =CONCATENATE(G9," ",I9) in AA9 to combine the values with a space. The ampersand operator or TEXTJOIN is generally more flexible for new formulas.

Excel & Data Problems