How to Combine cells in Microsoft Excel

How to Combine cells in Microsoft Excel

In this article, I am going to share with you how you can combine the cell in Microsoft Excel with some simple and easy steps. So, follow below some easy steps to know how to use the combined cell function of MS Excel.

Combine Cells in MS Excel

Step 1: The very first step is to open your saved spreadsheet or create dummy data to perform this function of MS Excel.

Step 2: In the below image I am sharing the first way to combine the cell, here I am using the ampersand function. We denote this with the “&” symbol.

Combine Cells in MS Excel

Step 3: Write the formula in the same way I have written in the above image “=A2&” “&C2”, here I have added space between & because in result this will shows like Rakesh Jain otherwise this will be like RakeshJain. See the below image.

Combine Cells in MS Excel

Now, let’s see another way to combine the cell, name of the other method is CONCATENATE.

CONCATENATE FUNCTION

By using this function, you can join two or more texts or string into one cell or sting, if you are using the older version of excel then, you can use this by writing CONCATENATA but if you have excel 2016 or the above then this is now CONCAT.

Step 1: Follow the same step as above.

Step 2: Start typing the formula like this in your new cell, where you want to perform this function.

Combine Cells in MS Excel

Here, also compulsory to use space between those two quotation marks, if you want space so, otherwise if you don’t want then remove the space.

Step 3: See below the result of the above-used formula.

Combine Cells in MS Excel

Thank you.

One comment on “How to Combine cells in Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *