Excel Tips Tutorial: How to Use Concatenate Function to Join Cells Together
In this tutorial we will show you how you can join data distributed in more than one cells together to make a combined data cell for using those data more efficiently. The equation used for this purpose is called concatenate(). Letís try it.
Letís take a look on following table of citizen data:
Here you can get information of individual citizens in different columns. It will be highly useful if we can combine all data of every single citizen in a single cell and represent that as a profile number of his or her. To do this lets name another column as citizen_profile
Click on cell F2 and write equation as ď=concatenate()Ē. Now, inside the parentheses (), write cell numbers which you like to combine i.e. B2,C2,D2,E2 etc with a separation of comma (,) between each two cells.
See below snapshot. Now press enter. Now you see, all those distributed cells you wanted to combine are getting together.
At this step, we will show you how you can make the same combining in all cells of the table.
Just select already combined cell F2. Right click on it and select copy. Select all cells from F3 to F17 like below picture. You will see cells marked with a blue shade.
Now, right click on selected cells and PASTE. The formulae will be automatically updated in appropriate cells. Now you see how easily from each output in Citizen_Profile column you can easily identify all the information of every citizen at a glance.