Google Sheets CONCAT Function | Join Two Values | How to Join Values with & (Concatenation Operator)
The Google Sheets CONCAT function joins two values. Each of the value, or both the values, can be numeric, alphabetic, or alphanumeric. The CONCAT function, unlike the JOIN function, does not allow the use of a delimiter.
You can also use the join operator & (ampersand) to join two or more values. Further, with &, you can use more than one delimiter to concatenate values.
------------------------------
If you wish to join more than two values with a delimiter, a Google Sheets
function you can use is JOIN. Here is the link to the step-by-step video
tutorial on the JOIN function:
• Google Sheets JOIN Function | Join a ...
------------------------------
Let's look at the format of the CONCAT function formula:
=CONCAT(value1, value2)
Start the formula with an equal-to symbol.
CONCAT is the name of the function.
value1 is the value to be joined with value2.
value2 is the value that follows immediately after value1.
Here are some examples of the CONCAT function formula:
Example 1
=CONCAT("book", "shelf")
The CONCAT function returns "bookshelf".
Example 2
=CONCAT("10", "000")
The CONCAT function returns "10000".
Example 3
=CONCAT("$", "5")
The CONCAT function returns "$5".
How to Use & (ampersand) to Join Two or More Values?
Say cell A1 has the text value "mail" and cell B1 has the value "box". To
concatenate cell A1 and B1 in cell C1, using & (ampersand), in cell C1, type:
=A1&B1
Google Sheets returns "mailbox".
Take a look at this video tutorial, which has two parts: The first part gives the steps to use the Google Sheets CONCAT function with examples. The second part gives the steps to use &, which is the join or concatenation operator, to join two or more values, with examples.