CONCATENATE function

Function Type:

Text

I'm sure not everyone knows what the word concatenate means so I'll start this post with a screenshot of quick Google Search.

Description:

CONCATENATE function in Excel to concatenate (join) strings in a chain or series. Instead of using CONCATENATE, simply use the ampersand & operator.
CONCATENATE will join texts together based on the order specified.

If we need to put texts that are not in a cell, we can add texts by enclosing these texts with double quotation marks " "

Function Structure:

=CONCATENATE(text1, [text2])

Another way to do this is using this structure below:

=text1 & text2

Argument Breakdown:

text1 - The first text to join together

[text2] - Next text to join together. Square bracket means this is an optional argument. Also you can concatenate as many texts as you want

But keep in mind that functions has a 255 character limit.

Example:

simple concatenate

this also works using this structure with ampersand &

concatenate with special characters

In this sample, I added a comma and space between 2 texts

you can also use this structure

concatenate texts not written in a cell

Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva