Description:
Join () Function returns a String that consist of array elements separated by the delimiter provided.
Format:
Join(arrArrayName[,delimiter])
Arguments:
- arrArrayName
- Mandatory
- Type: Array
- Array Name which needs to be converted into string.
- delimiter
- Optional
- If delimiter is provided then array elements will be concatenated and separated by delimiter provided and if delimiter is not provided the array elements will be concatenated without any spaces.
Example:
Function FnArrayJoin() Dim arrColor arrColor = Array("Red", "Blue", "Green", "Yellow") MsgBox Join(arrColor, "&") End Function