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.
 

Related Functions
LEFT
RIGHT
MID
ANCESTORS
CHILDREN
PARENT
Was this article helpful?
YesNo