How to Troubleshoot Excel Merge Cells and Combine Cell Contents
Question details
The user is trying to combine the text values from multiple cells but is facing issues because they are confusing data concatenation with the layout-based Merge Cells feature.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to merge multiple cells into one while retaining all the text data from the original individual cells.
- Observed behavior
- Pressing Enter after using standard merge instructions fails to combine the text strings and may result in data loss, as the user is applying visual formatting instead of a data joining formula.
Identify whether your goal is to create one large cell for layout purposes (formatting) or to merge the text from multiple cells into a single string (concatenation). Select a blank cell outside your main data range to safely test formulas.
Use Formulas to Combine Cell Contents (Concatenation)
Use the ampersand (&) operator or the CONCAT function to join text from multiple cells without losing any data.
When you want to keep all the text from multiple cells, you must use a formula rather than the visual merge tool. The ampersand (&) operator or functions like CONCAT and CONCATENATE allow you to combine text strings easily.
Click on a new, empty cell where you want the combined text to be displayed.
Type an equals sign (=) followed by your first cell reference, an ampersand (&), a space enclosed in quotation marks (" "), another ampersand, and the second cell reference. For example: =A1&" "&B1.
Alternatively, type =CONCAT(A1:B3) to quickly combine a contiguous range of cells, then press Enter to apply the formula.

Use Merge & Center for Layout Formatting
Use the built-in Merge & Center tool if you only need to create a wider visual cell for headers and do not need to combine text from multiple cells.
Combine and Merge Cells Easily with WPS Office
WPS Spreadsheet offers powerful and intuitive tools for both formatting cell layouts and concatenating text data, ensuring smooth data management and perfect compatibility with Excel files.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Combine cell contents with formulas: To join text from multiple cells, click a blank cell, type =CONCAT(A1, B1) or =A1&" "&B1, and press Enter.
- 3. Merge cell layouts visually: To combine the physical space of cells, highlight the target range, navigate to the 'Home' tab, and click the 'Merge and Center' icon.

Frequently Asked Questions
Why does merging cells delete my data?
The standard 'Merge & Center' feature is designed solely for formatting layouts. It is programmed to retain only the data located in the upper-left cell of your highlighted selection, discarding the rest. To keep all your data, you must use concatenation formulas instead.
Why is my CONCAT formula not working or showing an error?
Formula errors usually happen due to incorrect cell references. For instance, typing '=A&B' is invalid; you must specify the exact row and column coordinates, such as '=A1&B1'. Check your formula for missing ampersands or incorrect quotation marks.
How can I add a comma or other text between combined cells?
You can insert any characters between cell values by placing them inside quotation marks within your formula. For example, to add a comma and a space between cell A1 and B1, use the formula '=A1&", "&B1'.




