Home : Join
Q14554 - INFO: Join

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

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/22/2019 4:39 PM.
Last Modified on 10/23/2019 8:50 AM.
Last Modified by Scott Dorner.
Article has been viewed 144 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article