top of page

JOIN( ) & CONCATENATE( )

Sample Usage: =JOIN(" ",B8:D8)

​

Sintax: JOIN(delimiter, value_or_array1, [value_or_array2, ...])

image.png

Notes: JOIN() is useful when you want to join two or more cells by using the SAME delimiter. If you want to use different delimiters at the same time use CONCATENATE() instead.

Sample Usage: =CONCATENATE(B38," - ",C38," ",D38, " ")

or =CONCATENATE(B40," - ",JOIN(" ",C40:D40))

 

Sintax=CONCATENATE(string1, [string2, ...])

image.png
bottom of page