Concatenate featured image

The CONCATENATE function

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:

CONCATENATE FUNCTION
This is a screenshot of the CONCATENATE function used in the Word Jumble Template – Excel 2013

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).

CONCATENATE example
Using the CONCATENATE example with names – Excel 2013

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)

For more information about the CONCATENATE function, check out this article on Office Support.
 I hope this brief introduction to the CONCATENATE function has helped.
Take care!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s