Document Editing Problems

How to Combine Cell Contents and Remove Original Cells in Excel

Chanuka GeekiyanageChanuka Geekiyanage Nov 10, 2026 871 views

Question details

The user needs to merge text from two or more Excel cells, save the combined result as static text, and delete the original source cells without losing the merged data.

How to Combine Cell Contents and Delete Original Cells in Excel
Product
Spreadsheet
Device & OS
not provided
Scenario
Merging data from multiple columns into a single column and cleaning up the original source data.
Observed behavior
When deleting the original cells after using a concatenation formula, the combined result disappears or shows an error. The user needs a way to convert the formula to permanent text.
Before you start

Ensure you have an empty column or cell ready to place your combined formula before clearing any of the original data.

Solution 1Recommended

Use Concatenation Formulas and Paste as Values

Combine the cells using a formula, then use the Paste Special feature to convert the dynamic formula into permanent static text.

By default, combination formulas rely on the original cells to display text. If you delete the source cells, the formula breaks. Pasting the result as values removes the underlying formula, leaving only the final text, which allows you to safely delete the original data.

1
Enter the combination formula

Click on an empty cell and enter a formula such as `=A1&B1`, `=CONCAT(A1,B1)`, or `=CONCATENATE(A1,B1)`. Press Enter to display the combined text.

2
Copy the formula result

Select the cell containing your newly combined text and copy it by pressing Ctrl+C on your keyboard, or right-click and choose 'Copy'.

3
Paste as values

Navigate to the Home tab, click the drop-down arrow below the 'Paste' button, and select 'Paste as Values' (often depicted as an icon with the number 123). Alternatively, right-click the cell and choose 'Values' under Paste Options.

4
Clear the original cells

Now that your combined text is converted to a permanent value, you can safely select the original source cells (such as A1 and B1) and press the Delete key to clear them.

Use Concatenation Formulas and Paste as Values
Data Preserved: Pasting as values successfully severs the formula's link to the original cells, ensuring your combined data remains perfectly intact.
Manage Spreadsheet Data Easily

Use WPS Spreadsheet for Efficient Data Management

WPS Spreadsheet offers seamless formula integration and advanced Paste Special options, making it incredibly easy to merge cell contents, convert formulas to static values, and organize your datasets without data loss.

  1. 1. Open your spreadsheet in WPS Office: Launch WPS Spreadsheet and open the document containing the cells you wish to merge.
  2. 2. Apply a combination formula: Use `=CONCAT(A1,B1)` or `=A1&B1` in a new, empty column to merge your data.
  3. 3. Copy and paste as text: Select the combined cells, copy them, right-click, and select 'Paste as Values' to freeze the data.
  4. 4. Clean up original data: Select the old columns, right-click, and choose 'Delete' to remove the unnecessary original cells safely.
Fully compatible with Microsoft Excel (.xlsx) formats and formulas.Intuitive Paste Special menu to quickly convert formulas to text values.Lightweight, fast, and completely free to use.Includes powerful data cleaning tools to manage complex datasets efficiently.
QA img-9

Frequently Asked Questions

Why does my combined text disappear when I delete the original cells?

If you only use a formula like =A1&B1 without pasting as values, the result dynamically depends on the original cells. Deleting the original cells breaks the formula reference, resulting in an error or an empty cell.

How can I add a space between the combined cell contents?

To insert a space between the combined words, add a space enclosed in quotation marks within your formula. For example, use =A1&" "&B1 or =CONCATENATE(A1," ",B1).

Can I combine multiple columns at once instead of just two cells?

Yes, you can use the CONCAT or TEXTJOIN function to combine an entire range of cells, such as =CONCAT(A1:C1), before copying and converting them to values.

Is there a keyboard shortcut for Paste as Values?

Yes, after copying your formula results, you can use the shortcut Ctrl+Shift+V in many spreadsheet applications, or press Alt, then H, then V, then V sequentially to paste as values.