How to Combine Two Excel Cells with a Space, Comma, or Line Break in WPS Office
Question details
The user wants to combine values from two Excel cells into one cell using a space, comma, or line break as the separator.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has separate values, such as a person's name and address, in two cells and needs them joined in a single cell for display or output.
- Observed behavior
- The values are currently stored in separate cells and need a formula-based way to be combined with the desired separator.
Open your workbook in WPS Spreadsheets and note the cell references you want to combine. If the result should appear on multiple lines within one cell, confirm that Wrap Text can be applied to the target cell.
Combine two Excel cells on one line with a space or comma
Use this formula-based method when you need the combined result to stay on one line and be separated by a space, comma, or comma plus space.
The ampersand (&) operator joins text exactly as written in the formula. You can change the separator between the quotation marks to a comma, a space, or both.
Click the cell where you want the combined value to appear, such as C2.
Type =A2&", "&B2 and press Enter. Replace A2 and B2 with your actual cell references, and change ", " to " " or "," if needed.
Drag the fill handle from the formula cell down to apply the same combination to other rows.
Combine two Excel cells with a line break in the same cell
Use this method when you need the combined value to appear on separate lines inside one cell, such as a name above a street address.
Combine Excel Cells Easily with WPS Spreadsheets
WPS Spreadsheets supports the same Excel formulas and keyboard-friendly cell references, so you can combine two cells with a space, comma, or line break without changing your workflow. Open your existing .xlsx files, use the ampersand or CONCATENATE formulas, and keep the familiar Excel ribbon experience.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the workbook containing the cells you want to combine, or create a new sheet.
- 2. Enter the combination formula: Click the target cell and type =A2&", "&B2 for comma-space, or =A2&CHAR(10)&B2 for a line break.
- 3. Apply formatting: If you used CHAR(10), select the cell and click Wrap Text on the Home tab to show the line break.
- 4. Fill the remaining rows: Use the fill handle to copy the formula down, then save the file as .xlsx or your preferred Excel format.
Frequently Asked Questions
How do I combine two cells with a comma and space in WPS Spreadsheets?
Click the target cell and enter =A2&", "&B2, replacing A2 and B2 with your actual cell references. Press Enter to see the combined result.
Why does =A2&CHAR(10)&B2 show a square or no line break?
CHAR(10) inserts a line break, but it is only displayed when Wrap Text is enabled. Select the cell, go to the Home tab, and click Wrap Text.
Can I use CONCATENATE instead of the ampersand operator?
Yes. For example, =CONCATENATE(A2,", ",B2) combines A2 and B2 with a comma and space. The & operator is shorter and works the same way.
Should I permanently combine names and addresses into one cell?
It is usually better to keep separate data fields in separate columns. Combined text is harder to sort, filter, and split later, so combine only for display or export when necessary.
