JOIN

Joins values with delimiter.

Excel: No equivalent
Google Sheets: Not checked yet
Returns: Text

Examples

=JOIN(",", A1:A5)

	A
1	10
2	20
3	30
4	40
5	50

Result 10,20,30,40,50

=JOIN(" ", "Hello", "World")

Result Hello World

Syntax

JOIN(delimiter, value_or_array…)

delimiter: text required
value_or_array…: any required

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.