Use the Google Sheets TEXTJOIN function to join two or more values, using a single delimiter. A difference between TEXTJOIN and JOIN functions is that with the former, you can choose to ignore empty cells. That is, if there are one or more blank cells in the ranges you have specified, you can tell TEXTJOIN to ignore such cells by setting the ignore_empty attribute to true.

------------------------------
If you wish to join only two values, without a delimiter, you can use
the Google Sheets CONCAT function. Here is the link to the step-by-step video tutorial on CONCAT:

youtu.be/jBYe_9CiYS0

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:

youtu.be/bmF1cwPbfnU
------------------------------

Here's the format of the TEXTJOIN function formula:

=TEXTJOIN(delimiter, ignore_empty, text1, [text2, …])

Start the formula with an equal-to symbol.

TEXTJOIN is the name of the function.

delimiter is the string or the address of a cell, which has the string.

ignore_empty ignores blank cells in the specified range of a spreadsheet, if its value is TRUE; this attribute doesn't ignore blank cells, if its value if FALSE.

text1 is the single value, range, or array, in a spreadsheet, to be joined with text2, separated by the delimiter.

text2 is the single value, range, or array that follows immediately after the delimiter.

Let's look at some examples of the TEXTJOIN function formula:

Example 1

=TEXTJOIN(",", TRUE, "Pen", "Paper")

The function will return "Pen,Paper".

Example 2

Say you want to create the fill-in-the-blank question "1 inch=_____cms.", using TEXTJOIN.

Let's make some assumptions: Cell A1 has the text "1 inch=" and B1 has the text "cms.".

The TEXTJOIN function formula:

=TEXTJOIN("_____", TRUE, A1, B1)

will return "1 inch=_____cms."

If you wish to give a space between the end of the line and "cms.", press the spacebar once after the line. Now, the modified output will be:

"1 inch=_____ cms."

Example 3

Assume cells A1 to C1 have the values 1, 2, and 3 respectively, and cells A2 to C2 have the values 4, 5, and 6 respectively in a Google spreadsheet.

The TEXTJOIN function formula:

=TEXTJOIN(",", TRUE, A1:C1, A2:C2)

will return "1,2,3,4,5,6".

If you delete the value in cell A2 in the spreadsheet, what will this TEXTJOIN function return? It will return "1,2,3,5,6".

If you delete the value in cell A2 and use the below TEXTJOIN function formula, what will the function return?

=TEXTJOIN(",", FALSE, A1:C1, A2:C2)

The function will return "1,2,3,,5,6".

Take a look at this video tutorial, which gives the steps to use the Google Sheets TEXTJOIN function with examples.

• Google Sheets TEXTJOIN Function | Join Multiple Values with a Delimiter | Google Sheets Functions ( Download)
• Google Sheets Join Strings, Text in Cells - CONCATENATE, JOIN, &, JOINTEXT Functions Tutorial ( Download)
• How to combine text from multiple cells using TEXTJOIN in Google Sheets #sheetspinoy #techtita ( Download)
• How to Use the TEXTJOIN Function in Google Sheets ( Download)
• Google Sheets JOIN Function | Join a Value to Another Value | Google Sheets Functions ( Download)
• Combining Data using CONCATENATE, CONCAT, TEXTJOIN, and & in Google Sheets ( Download)
• Join Multiple Strings with a Delimiter in Google Sheets ( Download)
• Google Sheets Join, Textjoin & Concatenate ( Download)
• Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text | Concatenate with IF Condition ( Download)
• TEXTJOIN Function, Like VLOOKUP with Multiple Matches - Google Sheets Tutorial, IF, TEXTJOIN, Arrays ( Download)
• TEXTJOIN Google Spreadsheet #shorts #excel #googlesheets #spreadsheet ( Download)
• Google Sheets Duplicates Check & Extract: Powerful COUNTIFS, FILTER & TEXTJOIN Functions! ( Download)
• SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684. ( Download)
• Lookup with duplicate values in Google Sheets with TEXTJOIN ( Download)
• Google Sheets SPLIT Function | Split Text based on One or More Delimiters | Spreadsheet Tutorial ( Download)