How to combine multiple cells into 1 in Excel does not lose data

Excel cell aggregation is too familiar to those who often have to work with Excel. So how to include the cell without losing data on Excel?

How to include cells in Excel when not entering content when merging the cell with the content? For many new acquaintances with Excel, the merging of cells is one of the basic operations, but it is quite embarrassing between 2 types of cells. If you include the box on Excel and enter the content, it is quite simple. So if you include the content after entering the content, will the content disappear?

The following article will guide you how to combine multiple cells on Excel without losing data.

  1. How to combine 2 columns Full name in Excel does not lose content
  2. MS Excel - Lesson 4: Working with lines, columns, sheets
  3. Instructions on how to create diagonal lines in Excel box

1. How to merge multiple cells in Excel has not entered data

Step 1:

In the fields that the user wants to merge into 1, highlight and right-click and choose Format Cells .

How to combine multiple cells into 1 in Excel does not lose data Picture 1How to combine multiple cells into 1 in Excel does not lose data Picture 1

Step 2:

A new dialog box appears, click on the Alignment group and proceed with the customization as shown below.

Text alignment section:

  1. Horizontal: If Center is selected, the text is displayed in the middle horizontally.
  2. Vertical (vertical): Select Center to display text in the middle vertically.

Text control section:

  1. Select Wrap text to align content later in the middle.
  2. Select the Merge cells to perform cell pooling in Excel.

Finally, click the OK button below to proceed.

How to combine multiple cells into 1 in Excel does not lose data Picture 2How to combine multiple cells into 1 in Excel does not lose data Picture 2

The end result will be interface as shown below. The cells have been combined into 1 together. Next, you just need to enter the content and the text will be in the middle of the box because it was set up in advance.

How to combine multiple cells into 1 in Excel does not lose data Picture 3How to combine multiple cells into 1 in Excel does not lose data Picture 3

With Excel 2007 and above, users can immediately click on Merge & Center with a variety of options.

How to combine multiple cells into 1 in Excel does not lose data Picture 4How to combine multiple cells into 1 in Excel does not lose data Picture 4

2. Multi-cell Excel method does not lose data

We will take the example with the text below. Each letter is in a different cell and you need to merge them in one cell without losing data.

How to combine multiple cells into 1 in Excel does not lose data Picture 5How to combine multiple cells into 1 in Excel does not lose data Picture 5

Step 1:

Black out the entire number of cells to merge into 1 and then press Alt + F8, or Alt + Fn + F8 depending on the computer.

With Excel 2007 and above, you can highlight all the cells you want to merge and then click the View tab above the interface, select Macros on the Ribbon.

How to combine multiple cells into 1 in Excel does not lose data Picture 6How to combine multiple cells into 1 in Excel does not lose data Picture 6

With Excel 2003 , also black out the entire box and click on the Tools tab on the toolbar, select Macro to choose Macros .

How to combine multiple cells into 1 in Excel does not lose data Picture 7How to combine multiple cells into 1 in Excel does not lose data Picture 7

Step 2:

Appears the Macro dialog interface. In the Macro name bar, enter any name then press the Create button to create.

How to combine multiple cells into 1 in Excel does not lose data Picture 8How to combine multiple cells into 1 in Excel does not lose data Picture 8

Step 3:

The Microsoft Visual Basic window appears. Enter the code below into the middle of Sub QTM () . End Sub.

 Dim Cll As Range, Temp As String 
On Error Resume Next
If Selection.MergeCells = Then False
For Each Cll In Selection
If Cll <> "" Then Temp = Temp + Cll.Text + ""
Next Cll
Selection.Merge
Selection.Value = Left (Temp, Len (Temp) - 1)
Else
Selection.UnMerge
End If
Selection.HorizontalAlignment = xlCenter
Selection.VerticalAlignment = xlCenter

How to combine multiple cells into 1 in Excel does not lose data Picture 9How to combine multiple cells into 1 in Excel does not lose data Picture 9

Step 4:

When you have entered the above code, click on the File button and select Close and Return to Microsoft Exce l to close this interface and return to Excel.

This code will automatically be saved to the computer, unless the user reinstalls Win. The next use just press Alt + F8 and press Run to run the command.

How to combine multiple cells into 1 in Excel does not lose data Picture 10How to combine multiple cells into 1 in Excel does not lose data Picture 10

The results in the cells were combined into one box and no loss of data was shown.

How to combine multiple cells into 1 in Excel does not lose data Picture 11How to combine multiple cells into 1 in Excel does not lose data Picture 11

So we already know how to include multiple cells in Excel, in case the content or contents in different cells are not entered. The content after merging cells will not disappear but will remain the same as before.

See more:

  1. Use VLOOKUP to join two Excel tables together
  2. Instructions for dividing and merging columns on Google Docs
  3. Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells

I wish you all success!

5 ★ | 1 Vote