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.
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.
Now, let’s see another way to combine the cell, name of the other method is CONCATENATE.
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.
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.