Join combines the values in a cell range values together with a delimiter as a separator.
SYNTAX:
JOIN(Cell Range,Delimiter)
Cell Range: The cell range to join, i.e. B1:B5.
Delimiter: The character(s) that is placed between each value.
NOTES:
Returns a Text string. Cell type will be changed to Text when using this formula.
EXAMPLES:
|
|
A |
B |
C |
D |
E |
|
1 |
|
|
|
|
|
|
2 |
|
B2 |
C2 |
D2 |
E2 |
|
3 |
|
B3 |
C3 |
D3 |
E3 |
|
4 |
|
B4 |
C4 |
D4 |
E4 |
|
5 |
|
B5 |
C5 |
D5 |
E5 |
JOIN(B2:B5,",") = B2,B3,B4,B5
JOIN(B2:E3,",") = B2,C2,D2,E2,B3,C3,D3,E3 (NOTE: Loops thru Columns then Rows)
JOIN(B2:C3,"") = B2C2B3C3
SEE ALSO: Split, CONCAT