Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

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
      • 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.

Example:

Function FnArrayJoin()

  Dim arrColor

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

    MsgBox Join(arrColor, "&")   

End Function

 

Join

Join

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: