Syntax
=JOIN(delimiter, value_or_array1, [value_or_array2], ...)Arguments
| Argument | Required | Description |
|---|---|---|
delimiter | Required | Text to put between the values |
value_or_array1 | Required | A value or range |
value_or_array2 | Optional | More values or ranges |
How to use JOIN
JOIN takes 2 required arguments and 1 optional argument, and accepts more values in the same pattern. Type =JOIN( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=JOIN("-", 1, 2, 3)Result =JOIN(", ", {"a","b","c"})Result Related text functions
- FINDReturns the position of one text inside another, matching upper and lower case exactly.
- FINDBSame as FIND, counting bytes; without a double byte language set as default each character counts as one byte.
- FIXEDRounds a number to a number of decimals and returns it as text, with or without thousands separators.
- JISChanges half width (single byte) characters to full width (double byte) characters.
- LEFTReturns the first characters of a text.
- LEFTBSame as LEFT, counting bytes; without a double byte language set as default each character counts as one byte.
- LENReturns the number of characters in a text.
- LENBSame as LEN, counting bytes; without a double byte language set as default each character counts as one byte.
- LOWERConverts text to lowercase.