JOIN Function

Combines a range of cells into a string with optional delimiters between the values.
Sample Usage
JOIN([Task Name]2:[Task Name]6, " - ")
Syntax
JOIN(
  • range
  • [
    delimiter
    ]
)
  • range
    The group of cells to join.
  • delimiter
    —[optional]
    The value to separate the values in the range, for example: a hyphen, comma, or space. If no delimiter is provided, the values from the range will be joined without spaces. For example: "Task ATask BTask C"
Usage Notes

This is a good alternative to using + (the plus sign) to concatenate text.
 

Examples

This example references the following sheet information:

 Clothing ItemItem NumberOrder DateShip Date
1T-ShirtC00102/12/1902/15/19
2PantsC00202/15/1903/20/19
3JacketC00302/20/1902/27/19

Given the table above, here are some examples of using JOIN in a sheet:

FormulaDescriptionResult
=JOIN([Clothing Item]1:[Item Number]1, ": ")Returns the values in the “Clothing Item” and “Item Number” columns for row 1, separated by colon and a spaceT-Shirt: C001
=JOIN([Clothing Item]1:[Clothing Item]3, ", ")Returns the values in the “Clothing Item” column for rows 1 through 3, separated by comma and a spaceT-Shirt, Pants, Jacket
=JOIN([Order Date]3:[Ship Date]3, " - ")Returns the dates in the “Order Date” and “Ship Date” columns for row 3, separated by a space, then dash, then another space02/20/19 - 02/27/19
Was this article helpful?
YesNo