Return to VBA Code Examples

VBA Join Function

Join Description

Joins a number of substrings into a single string.

Simple Join Examples

This will display as following.

Join Syntax

In the VBA Editor, you can type  “Join(” to see the syntax for the Join Function:

The Join function contains 2 arguments:

SourceArray: 1d array containing substrings to be joined.

Delimiter: [Optional] Delimiter. If omitted, the space character (” “) is used.

Examples of Excel VBA Join Function

Result: C:\Users\Public

Result: “A, B, C”

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! vba save as

Learn More!