Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Array Functions – Join() – Converts Array to String


 Join () Function returns a String that consist of array elements separated by the delimiter provided.



  • arrArrayName
    • Manda­tory
    • 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.


Function FnArrayJoin()

  Dim arrColor

    arrColor = Array("Red", "Blue", "Green", "Yellow")    

    MsgBox Join(arrColor, "&")   

End Function

Also Read:

  1. VBA-Excel : Strings Functions – InstrRev
  2. VBA-Excel: Date-Time Functions – IsDate()
  3. VBA-Excel: Date-Time Functions – DatePart()
  4. VBA-Excel: Fill Excel Range Values in a 2D Array
  5. VBA-Excel: Array Functions – Filter()
  6. VBA-Excel: String Functions – Trim()
  7. VBA-Excel: CurrentRegion
  8. VBA-Excel: Date-Time Functions – DateSerial()