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: Array Functions – LBound and UBound()
- VBA-Excel: String Functions – strComp()
- VBA Excel – Refer to Multiple Ranges : Union Method
- VBA-Excel: Date-Time Functions – DateAdd()
- VBA-Excel: Delete Blank Rows from Excel Work Sheet