Text Join And Concatenate Formula in Google Sheets

Text Join And Concatenate Formula in Google Sheets

The TEXTJOIN and CONCATENATE formulas in Google Sheets are used to combine text from different cells or ranges into a single cell. Here's an overview of each formula:

1. TEXTJOIN: This formula is used to join text strings from a range of cells, and you can specify a delimiter to separate each string. The basic syntax is:

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

The "delimiter" argument is the character or characters you want to use to separate the text strings. The "ignore_empty" argument specifies whether to ignore empty cells in the range. The "text1" argument is the first cell or range to join, and you can include additional cells or ranges separated by commas.


2. CONCATENATE: This formula is used to join up to 30 text strings together into a single cell. The basic syntax is:

=CONCATENATE(text1, [text2, ...])

The "text1" argument is the first string to join, and you can include additional strings separated by commas.

Here's an example of how to use the TEXTJOIN formula in Google Sheets to combine a list of names into a single cell, separated by commas:

=TEXTJOIN(", ", TRUE, A2:A6)

In this example, the formula uses a comma and a space as the delimiter, and the "TRUE" argument tells the formula to ignore empty cells. The "A2:A6" argument specifies the range of cells containing the names to join.

And here's an example of how to use the CONCATENATE formula in Google Sheets to combine three cells into a single cell:

=CONCATENATE(A2, " ", B2, " - ", C2)

In this example, the formula joins the text in cells A2, B2, and C2 into a single cell, separated by a space and a hyphen.