How to Combine and Merge Two Cells in Excel: Easy Methods Explained

Have you ever found yourself struggling with scattered data and wondering How to Combine Two Cells in Excel? Whether it’s merging names, creating labels, or tidying up your reports, Excel offers quick methods to bring information together.

In this blog, we’ll walk you through simple and effective ways on How to Combine Two Cells in Excel, as well as when to merge cells for formatting. By the end, you’ll know how to make your spreadsheets both organised and visually appealing. Let’s get started!

Table of Contents 

1)  2 Methods to Combine Cells in Excel

   a) How to Combine Cells in Excel Using the Ampersand (&) Symbol?

   b) How to Combine Cells in Excel Using the CONCAT Function?

2) How to Merge Cells in Microsoft Excel?

   a) Merge Cells in Microsoft Excel

3) Shortcut for Merging Cells in Excel

4) Conclusion

2 Methods to Combine Cells in Excel

Combine Cells in Excel is a handy feature that helps you bring data together into one cell for easier viewing and organisation. Whether you’re preparing reports, creating labels, or formatting tables, Excel makes it simple. Now, we’ll see how to combine and merge cells using different methods.

1) How to Combine Cells in Excel Using the Ampersand (&) Symbol?

The ampersand symbol & is one of the easiest and most commonly used ways to join text or numbers from multiple cells. It’s quick, flexible, and doesn’t require Advanced Excel Skills.

1) Select the cell where you want the combined value to appear

2) Type a formula using & to join the contents of two or more cells

3) For example:

 If cell A1 contains Joe and cell B1 contains Root, enter:

 =A1 & " " & B1

4) Press Enter, and Excel will display: Joe Root

5) Now, repeat the formula for other rows to instantly combine names like Ben Stokes, Jos Buttler, and more.

2) How to Combine Cells in Excel Using the CONCAT Function?

The CONCAT function is another powerful method for combining cell values. It is more modern than the ampersand method and is specifically designed for concatenation tasks.

1) Select the cell where the combined result should appear

2) Use the formula:

 =CONCAT(A1, " ", B1)

3) Press Enter. The values in A1 and B1 will be combined with a space in between

How to Merge Cells in Microsoft Excel?

So far, we’ve looked at ways to combine the contents of cells into one. But sometimes you might want to merge cells, which means joining multiple cells into one larger cell, often for formatting or presentation purposes. Understanding How to Merge Cells in Excel helps you create cleaner headers, organised reports, and professional-looking spreadsheets.

Merge Cells in Microsoft Excel

1) Select the cells you want to merge

2) Go to the Home tab on the Excel ribbon

3) Click the Merge & Centre dropdown

4) Choose one of the options:

   a) Merge & Centre: Combines cells and Centres the text

   b) Merge Across: Merges cells in each row individually

   c) Merge Cells: Merges without Centring text

   d) Unmerge Cells: Reverts merged cells to their original state

Organise, analyse, and visualise as an Excel Expert! Register for our Excel Training with Gantt Charts now!

Shortcut for Merging Cells in Excel

If you frequently merge cells for formatting, knowing a shortcut can save time.

Windows Shortcut

Press Alt + H + M + C to quickly merge and Centre selected cells.

Mac Shortcut

Excel for Mac doesn’t have a direct shortcut. However, you can customise your keyboard shortcuts or use the toolbar option under Format > Merge Cells.

Using shortcuts helps speed up repetitive formatting tasks when working on large reports or dashboards.

Learn essential Excel functions to manage accounting data more efficiently – register in our Excel for Accounting Course today!

Conclusion

Mastering How to Combine Two Cells in Excel is a practical skill that makes data handling smoother. It allows you to organise details, create clear labels, and design professional reports. Start practising these methods today, and you’ll quickly see how much easier working with spreadsheets can become.

From basics to brilliance-upgrade your Excel skills with Business Analytics with Excel Course today!