In this Article I will guide you how to concatenate multiple cells quickly using different methods using examples.
Concatenation of cells means clubbing the data of many cells into one cell. Sometimes we confuse merge cells with concatenate cells.
When you merge cells, you "physically" merge two or more cells into a single cell. As a result, you have one larger cell that is displayed across multiple rows and/or columns in your worksheet.
When you concatenate cells in Excel, you combine only the contents of those cells. In other words, concatenation in Excel is the process of joining two or more values together.
Difference between these two methods:
We have an inbuilt concatenate function in Excel in the following format:
=CONCATENATE(text1, [text2], …)
For example if we want to concatenate data from cell A1, B1
The results explain this.
We can also use strings in the formula itself as explained in the following example
=CONCATENATE(A1,B1, “I am 40 years old”)
We can also use formula calculated values like dates as explained in the following example:
=CONCATENATE(A1,B1, " Today is ",TEXT(TODAY(), "dd-mmm-yy"))
Which gives the following result: