How to Merge Cells in Excel in 2 Easy Ways

-

|

Introduction

You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has a merge tool, when you merge cells in Excel with data, you will lose the data on the right-hand cell.

In the sheet below, when I tried to merge Cells B5 and C5, I received the warning shown.

And here is the result. I lost the second name!

This guide will show you how to merge cells in excel without losing your data.

How to Merge Cells in Excel with CONCATENATE

The table below shows student names in two columns. First Name and Last Name. Say your boss sent you a sheet with thousands of names. You are required to to merge the names into a single column.

How to Merge Cells in Excel with CONCATENATE

In this example, I will demonstrate how to merge the two cells into one using the CONCATENATE.

The syntax of this Excel function is:

CONCATENATE(text1, [text2], [text3]) 

For this example, text1 and text2 are the two cells you wish to merge.

To merge cells in columns B and C into a single column in D, follow the steps below:

  • On cell D5, enter the formula:
=CONCATENATE(
  • Then select cell B5 and enter a coma (,). Next, select cell C5. Next to C5 enter a closing bracket “)” and press Enter. The two cells will merge into a single cell as shown in the second image below. But there is a problem. There is no space between the names!
How to Merge Cells in Excel with CONCATENATE
  • To add a space between First and Last name, modify the formula as shown below:
=CONCATENATE(B5, " ", C5)
The formula is the same as the first with a slight variation. The only difference is that the last one (above) includes quotes, ” ” with a space between them.
  • Here is the result using the modified formula above.
You can use this method to add other characters between the names. For instance if you want to reverse the position of the first and last name and include a comma after the last name, use the formula below.
=CONCATENATE(C5, ",", " ", B5)

The formula simply reversed the position of the cells. It also includes a comma (,) and a space. Here is the result in Excel.

How to Merge Cells in Excel with “&” (Ampersand)

How to Merge Cells in Excel with “&” (Ampersand)

Another easy way to merge cells in Excel is to use the “&” (Ampersand) operator.

The syntax of & operator is:

 text1 & [text2] & [text3] 

It is very similar to CONCATENATE. But instead of separating the cells with a comma (,), the cells are separated with “&”.

Refer to the image above. In this example, I will show how to merge cells C5 and D5 in E5.

To merge cells in Excel using “&” (Ampersand) follow the steps below:

  • On cell E5, enter the formula:
=B5&C5
  • The result will merge the cells without any space.
  • To merge the cells in Excel and include a space between the names, modify the formula as shown below:
=B5&" "&C5
Just like the previous example, adding a space is as simple as adding two quotes ” ” with a space between the quotes. The cells will merge with a space between them. See the image below.
How to Merge Cells in Excel with “&” (Ampersand)

Conclusion

To merge cells in Excel is as simple as I have shown in this guide. The two methods shared in this guide can also be used to merge more than two cells in Excel. I hope it was helpful. If you want to learn more about the methods used in this guide click How to Concatenate Columns and Strings.

If you have any question regarding how to merge cells in excel, use the “Leave a Reply” form at the end of this page. Better still, you could share your experience.

Other Helpful Guides

Additional Resources and References

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

ADVERTISEMENTS

BEST OF ITECHGUIDES

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...
FTP and SFTP ports

FTP and FTP Port, SFTP and SFTP Port: Quick Reference

Introduction FTP and SFTP are two protocols for transferring files between a server and a client computer. FTP port...
How to Empty Google Drive Trash

How to Empty Google Drive Trash (from the Drive App or a PC)

Introduction This is a demo guide on how to empty Google Drive trash. One of the reasons you may...
How to Hide Birthday on Facebook

How to Hide Birthday on Facebook (from the App or a PC)

This Itechguide teaches you how to hide birthday on Facebook. The guide offers separate steps to hide birthday on Facebook from the...

How to Format a New Hard Drive in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to format new hard drive in Windows 10. Options...

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....

AMAZON DEALS

MUST READ

active directory interview questions

35 Active Directory Interview Questions and Answers

I have compiled 35 Active Directory interview questions and answers. Where necessary, I have also provided additional information to help you understand...
How to Install Windows 10 1903 with WSUS

How to Install Windows 10 1903 with WSUS

Introduction This guide demos how to install Windows 10 1903 with WSUS. The steps in...
what is active directory

What is Active Directory (Top 50 AD Questions Answered)

Introduction This article answers the question - What is Active Directory and 49 other most widely asked AD questions....
powershell executionpolicy

PowerShell ExecutionPolicy Explained

What is PowerShell ExecutionPolicy? ExecutionPolicy in PowerShell is a security feature that controls how PowerShell loads configuration files and...
vlookup google sheets

How to Use VLOOKUP in Google Sheets

Introduction VLOOKUP (Vertical lookup) in google sheets is used to search for a value in the first column of...

AMAZON DEALS

By using this website you agree to accept our Privacy Policy and Terms & Conditions