formulasgoogle sheets
I want to use the JOIN formula in Google Spreadsheets to transform all values in one column into a list, with , around each value.
Has anyone used this formula before? The only information I can find is the Google documentation—which describes it as =JOIN( delim, array_1, ...)—however, I don't understand what delim and array_1 refer to.
Google Spreadsheets uses 'грн.' to identify hryvnia. To use the currency Google tells us we need to:
You can also add Custom Currencies (like ₴) using the 123 menu as in the screenshot below.
Type in the currency you want:
and you will be able to select them:
If you don't want to use the column-name-in-the-first-row approach mentioned in the answer you have linked to, then you can:
NB This works in Google Sheets files created since the "new" version was released, and older ones converted to the new format. I don't know if the feature is available in others - perhaps not, if you have difficulty finding it.
Worked example: here
Best Answer
Delim means delimiter
array_1 means the cells you want to use.
Will put a comma between each value from cells b1 to b4. The result appears in the cell where you put the formula.
Note: the cells must be in the form as 1xN or Nx1 array. In other words all in the same row, or all in the same column.