CONCATENATE Function
Explanation
The CONCATENATE function in Excel allows us to merge text from multiple cells into one cell. This can be useful for creating a single, combined string of text from several sources.
Syntax, The syntax of the function, is simple: =CONCATENATE(text1, text2, text3…) text1, text2, text3, etc. – the text strings we’d like to combine into one cell. These can be individual cell references or direct text entries in quotation marks. Note that the “=CONCATENATE()” function can only combine text and cannot be used to perform calculations.
It is worth noting that there are newer functions that may be better alternatives for combining text, such as the =TEXTJOIN and =CONCAT functions, or use the Flash Fill.
Example
For example, if we have text in cells A1, B1, and C1, we can combine these into one cell by entering “=CONCATENATE(A1,B1,C1)” into another cell. This will result in a single cell that contains the combined text from all three cells.
Concatenate – Exercise