Google Sheets JOIN Function

This post will guide you how to use Google Sheets JOIN function with syntax and examples.

Description


The Google Sheets JOIN function joins two or more text strings together and separated by a delimiter. you can select an entire range of cell references to be combined in Google Sheets. and you can also specify an empty string as delimiter to include between each text in different cells.

The JOIN function can be used to concatenate the items of one or more one-dimensional arrays using a specified delimiter in Google Sheets.

The JOIN function is a build-in function in Google Sheets and it is categorized as a Text Function.

Syntax


The syntax of the JOIN function is as below:

JOIN (delimiter, value_or_array1, [value_or_array2, …])

Where the JOIN function arguments are:

  •  delimiter -This is a required argument. It can be a text string or empty string to join text values with a given delimiter, it can be a space, comma, hash character or other text string.
  • value_or_array1 – This is a required argument.  One or more strings that you want to concatenate.

Notes:

  • The JOIN function takes two required arguments: delimiter and array1. Delimiter is a text character that to be used between array elements that are concatenated together. And the delimiter character should be enclosed in double quotes. You can also specify the delimiter as blank, just supply an empty string. Array1 is the first value to join together. It can be a cell reference, cell range, text string values or one one-dimensional array. You can also supply the additional value or array that to be appended using a specified delimiter character.
  • If delimiter argument is omitted, the result of JOIN function is similar to the CONCATENATE function in google sheets.

Google Sheets JOIN Function Examples


The below examples will show you how to use Google Sheets JOIN function to join two text strings with a delimiter.

#1 To join strings in B1,C1,D1 cells, just using formula:

= JOIN (",",B1,C1,D1)

Google sheets join function

#2 To join values from the multiple cell ranges with a double dash character as delimiter. using the following formula:

=JOIN("--",B1:B6,C1:C6)

Google sheets join function

x
How to Select Every Other Row in Excel

#3 to join string in range cell A1:C1 by a comma character as delimiter and empty cells should not be ignored. using the following formula:

 =join(",",B1:B9)

Google sheets join function

 

Related Posts

Google Sheets MIDB Function
google sheets midb function1

This post will guide you how to use Google Sheets MIDB function with syntax and examples. Description The Google Sheets MIDB function returns a substring (a specified number of bytes) starting from the middle of a text string and up ...

Google Sheets MID Function
google sheets mid function

This post will guide you how to use Google Sheets MID function with syntax and examples. Description The Google Sheets MID function returns a substring (a specified number of the characters) starting from the middle of a text string. The ...

Google Sheets LOWER Function
google sheets lower function1

This post will guide you how to use Google Sheets LOWER function with syntax and examples. Description The Google Sheets LOWER function converts all characters in a text string to lowercase. The LOWER function can be used to convert a ...

Google Sheets LENB Function
google sheets lenb function1

This post will guide you how to use Google Sheets LENB function with syntax and examples. Description The Google Sheets LENB function returns the length of a text string in bytes. The LENB function can be used to count the ...

Google Sheets LEN Function
Google sheets len function1

This post will guide you how to use Google Sheets LEN function with syntax and examples. Description The Google Sheets LEN function returns the length of a text string (the number of characters in a text string). The LEN function ...

Google Sheets LEFTB Function
google sheets leftb function

This post will guide you how to use Google Sheets LEFTB function with syntax and examples. Description The Google Sheets LEFTB function returns a substring (a specified number of the bytes) from a text string, starting from the left portion. ...

Google Sheets LEFT Function
google sheets left function

This post will guide you how to use Google Sheets LEFT function with syntax and examples. Description The Google Sheets LEFT function returns a substring (a specified number of the characters) from a text string, starting from the leftmost character. ...

Google Sheets FIXED Function
google sheets fixed function1

This post will guide you how to use Google Sheets FIXED function with syntax and examples. Description The Google Sheets FIXED function rounds a number to the specified number of decimal places and returns the result as text string and ...

Google Sheets FINDB Function
Google sheets findb function 1

This post will guide you how to use Google Sheets FINDB function with syntax and examples. Description The Google Sheets FINDB function returns the position of the first text string (sub string) within another text string counting each double-character as ...

Google Sheets Find Function
google sheets find function

This post will guide you how to use Google Sheets FIND function with syntax and examples. Description The Google Sheets FIND function returns the position of the first text string (sub string) within another text string. The FIND function can ...

Sidebar