Combine a number of substrings contained in a list (array) into a single string value.
Syntax Join(list[, delimiter]) Key list A one-dimensional array containing substrings to be joined. delimiter A string character used to separate the substrings in the returned string. If omitted, the space character (" ") is used. If delimiter is a zero-length string, all items in the list are concatenated with no delimiters.
join the substrings of MyArray:
MyArray(0) = "Mr."
MyArray(1) = "John "
MyArray(2) = "Doe "
MyArray(3) = "III"
MyString = Join(MyArray) ' MyString contains "Mr. John Doe III".
“There's zero correlation between being the best talker and having the best ideas” ~ Susan Cain
Array - Add values to an Array variable.
Split - Parse a string of delimited values into an array.