
Let us see what each of these options is in detail. So you might have the question – What is the correct and most effective way to merge cells in Excel? Here’s the answer to that. Now we shall discuss the two best ways to merge cells in Excel. This is the main drawback of using the “Merge & Center” option. Due to this, we did get a merged cell, but we lost the “Last Name” in the process. So, what happened here is that Excel merged the two cells together instead of the cell values. Step 5: Once we click on “OK”, we shall get the following result Step 3: The moment we click on “Merge & Center”, we get a dialogue box pop up showing a warning, mentioning that only the left-hand value would be considered, and the right-hand value would be discarded. Step 2: We will click on the “Merge & Center” option on the Home ribbon next. In this scenario, we shall select cells A2 and B2. Step 1: We will need to select the cells that we wish to merge together.

If we wish to merge the contents of “First Name” and “Last Name”, then this method fails as it takes only the left-hand value, completely overwriting the right-hand values. We have a list where the first column (A) contains the first names and the second column (B) has the last names. Let us look at an example to get a better understanding of this drawback. If we have some data in cells A1 and B1, using this form of merging would result in the retention of the left-hand value and the overwriting of the right-hand value. There is, however, a drawback with this method of merging. Perhaps the most used and one of the simplest ways to achieve this using the “Merge & Center” option available in the Home ribbon. Merging essentially means having the combined values of multiple cells in one.

#Merging cells in excel with text how to
For example, you can learn how to remove duplicate rows or password protect your document.Excel functions, formula, charts, formatting creating excel dashboard & others Merge Cells in Excel Using Merge & Center Option If you found this useful, you may want to try some of our other Excel tutorials. You should now know how to combine cells in Excel even if they’re on completely different sides of your spreadsheet. The concatenate will automatically apply to them, moving incrementally down the columns you specified in your formula. Release your mouse button to fill the rest of the rows.Instead, click the original cell, then click on the green dot in its bottom right corner and drag it down. If you need to apply the formula to other cells in your column, don’t waste your time copy and pasting. Optional: Copy your formula to other rows in your column.Your final formula would look something like this: This can be easily achieved by adding " " between the two cells the formula. You’ll want many strings you combine to have a space between them. Optional: Add a space to your concatenation.If you’d like to add a space, continue to the next step.

You’ll see the two strings directly next to each other with no space. Click on the cells you’d like Excel to combineĪfter you open your bracket, click the starting cell, followed by the cell you’d like to combine it with.In the cell where you’d like the combined result to display, type =CONCATENATE(. Type the CONCATENATE formula in your cell.Here’s how you can perform concatenation in Excel: The cells it pulls from do not have to be next to each other, though this may make it easier to organize.

Concatenating allows you to create a new column that references existing data on your spreadsheet to create a new combined cell.
