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 () Func­tion returns a String that con­sist of array ele­ments sep­a­rated by the delim­iter provided.

Format:

Join(arrArrayName[,delimiter])

Arguments:
    • arrAr­ray­Name
      • Manda­tory
      • Type: Array
      • Array Name which needs to be con­verted into string.

  • delim­iter
    • Optional
    • If delim­iter is pro­vided then array ele­ments will be con­cate­nated and sep­a­rated by delim­iter pro­vided and if delim­iter is not pro­vided the array ele­ments will be con­cate­nated with­out any spaces.

Exam­ple:

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: