Be the first user to complete this post
|
Add to List |
VBA-Excel: Array Functions – Join() – Converts Array to String
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
Also Read:
- VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
- VBA-Excel: Arrays – Two Dimensional, Static Array
- VBA Excel - Cells, Ranges and Offset : Offset
- VBA-Excel : Strings Functions – Lcase
- VBA-Excel: Date-Time Functions – FormatDateTime()