Excel VBA Join Function: The Join function in VBA is used to join an array of substrings and return them all as a single string.

Syntax

Join (SourceArray, [Delimiter])

Parameter

SourceArray (required) – This parameter represents an array of substrings that you want to join.

Delimiter (optional) – This parameter represents a delimiter used to separate the substrings while making up the new string. The default value is set to “ ”.

Return

This parameter returns a single string after joining the given array of substrings.

Example 1

Sub JoinFunction_Example1()
 ' Joining the strings of arrays together into a single Array.
 Dim fullName As String
 Dim names(0 To 2) As String
 names(0) = "Amar"
 names(1) = "Chandra"
 names(2) = "Panda" 
 fullName = Join(names)
 ' The variable fullName will return "Amar Chandra Panda"
 MsgBox ("Your full name is " & fullName) 
 End Sub

Output

Example 2

Sub JoinFunction_Example2()
 ' Joining the strings of arrays together into a single Array.
 Dim address As String
 Dim names(0 To 4) As String
 names(0) = "House No:823 "
 names(1) = "C-Block"
 names(2) = "Plot-2"
 names(3) = "Rajouri Garden" 
 names(4) = "Delhi"
 address = Join(names, ", ")
 ' The variable fullName will return "House No:823, C-Block, Plot-2, Rajouri Garden, Delhi  "
 MsgBox ("Address:  " & address)
 End Sub

Output