Skip to content
Google Sheets

JOIN function in Google Sheets

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

=JOIN(delimiter, value_or_array1, [value_or_array2, ...])

JOIN syntax and parameters

Three arguments, two required.

  • delimiterstringRequired

    The character or string to place between each concatenated value. delimiter may be specified as blank, e.g. JOIN(,{1,2,3}).

  • value_or_array1anyRequired

    The value or values to be appended using delimiter.

  • value_or_array2anyRepeating

    [ OPTIONAL ] - Additional value or array to be appended using delimiter.

JOIN examples

Formulas you'll actually reuse.

  1. A comma-separated list from a column:

    =JOIN(", ", A2:A10)

    Result"Berlin, Vienna, Zurich"

  2. Open items as a line-separated list (turn on wrap text):

    =JOIN(CHAR(10), FILTER(A2:A50, B2:B50 = "open"))

JOIN in Excel

No direct equivalent — here's the way around.

Try JOIN in the playground

Edit the example — nothing to install.

Preloaded with the JOIN formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.