BOL’s description of the JOIN() Function: “Returns a string created by joining a number of substrings contained in an array.”. The syntax of the function is as follows:
=JOIN(List [,delimiter])
List – Required. One-dimensional array containing substrings to be joined
Delimiter – Optional. String character used to separate substrings. If omitted, a space “ “ will be [...]
