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

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

Output

VBA Join Function

Example 2

Output

VBA Join Function

Pin It on Pinterest

Share This