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:

https://youtu.be/bmF1cwPbfnU
——————————

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/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.