Combining Two or more cells into one cell | How To Combine Data Multiple Cells Into One Cell In Excel | atozlatests

 

How to Combine Multiple Cells into one cell?.

 Learn about combined operation in excel but before we begin let me tell you guys that we have daily updates on multiple technologies so if you're a tech geek in a continuous hunt for latest technological trends. Simply learn now without further let's get started so for example let us imagine that you wanted to create one single cell for all the employees in your company which stores the first name second name or last name including the email ID at one place right if you want to do so like let us let us let me show you how it looks like so let me copy this here then that's the first name now it's your second name along with the email ID.

Now let us imagine that you wanted to store all the employees in the same way right so you can do this by using combine operation in excel now all it takes is just a simple formula that is equals to and the first cell address that is A2 and you can use an ampersand sign now you can use the next cell reference set as B2 and then colon and the last cell address that is A2 now press enter so when you press enter or tab you will get this particular answer but this data is completely in a state where you can't understand it right the first name last name and the email ID has got combined all together so you want to use some spaces right so all you need to do is just make a little modification to this particular existing data so you can press another ampersand and include spaces. And then you can separate the email ID and the name with some column.

                             

                                   Follow Few Step to Combine Multiple Cells into One Cell

                                    Process of multiple cells into one cell

 1. Select the cell in which you want to insert the merged data.

 2. Type = then select the first cell you want to merge.

 3. Type and use quotation marks in a closed space.

4. Select cell you want to merge and hit enter. An example of a formula can be = A2 & "" & B2& " : " &E2 and press enter.

So now we have separated the first two cells that is the first name of the last name with the space using the ampersands and then again we have used an ampersand to include the column and see that we have also included a space between the column marks. That it gets separated cleanly and now let's try to press tab and see the result so there you go the first name and the second name is separated by space and the email ID and the complete name is separated by a column now you can use this to all the cells and there you go all the first name and last name. 

The email ID have been printed here so, that's how you use the combine operation in excel. I hope this session was informative and interesting. If you have any queries regarding any of the topics covered in this session then please feel free to let us know in the comment section below.

ALSO READ : WhatsApp Excess Colorful Heart Emoji’s In Beta Updates