The CONCATENATE function in Excel is essentially glue. It joins two or more things together.
How does the CONCATENATE function work?
If we wrote the function out as a sentence, it would probably be close to this:
Join together these words (Word 1 space Word 2 space Word 3 space Word 4)
But in Excel, it actually looks like this:
If we wrote the function out in Excel, it would look like this.
=CONCATENATE(A1,” “,B1,” “,C1,” “,D1)
Another use of this function is to connect names. Let’s use Brad Pitt’s full name as an example (reference).
The CONCATENATE function connects A2, B2 and C2 together to form the full name. The spaces are created by adding ” ” between each cell reference. The formula looks like this:
=CONCATENATE(A2,” “,B2,” “,C2)