> As detailed on this page, the ARRAYJOIN function is supposed to let you choose a separator. However, no matter what I type for the separator, it remains as a comma without a space after it.
The relevant part of my formula code:
(ARRAYJOIN(Author, ", ")
{Author} contains two items in the array: “Surname, Name” and “Surname2, Name2”.
What I get after ARRAYJOIN: “Surname , Name,Surname 2, Name2”.
Just in case, my full formula code:
SUBSTITUTE(CONCATENATE(SUBSTITUTE(ARRAYJOIN(Author, “, “), '”’, ‘’), " (”, Year, "). ", Title, ". ", Publication, ", ", Volume, “(”, Issue, "), ", Pages, “.”), “()”, “”)