Join function

Category: String / Text

Summary

Join array to string.

Syntax

Join(sourcearray, [ delimiter ]) The Join function syntax has these named arguments:
Part
Description
sourcearrayRequired. One-dimensional array containing substrings to be joined.
delimiterOptional. 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.

Microsoft Support Page

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/join-function

Back to Functions