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.

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

    VBA-Excel: Array Functions – Split()

    Description:

     Split() Function returns one dimensional array containing the substrings, after splitting the main string based upon the delimiter provided.

    Format:

    Split(strMainString [, delimiter[,intlimit[, vbCompare]]])

    Arguments: