VBA Left Function: The Left function in VBA returns a substring from the start of the specified string.

Syntax

Parameter

Str (required) – This parameter represents the string that you want to extract a substring.

Length (required) – This parameter represents the length of the substring.

Return

This function returns a substring from the start of a specified string.

Example 1

Output

Wel

Excel VBA Left Function

Example 2

Output

Welcome to V

Excel VBA Left Function

Example 3

Output

JWelcom

Excel VBA Left Function

Pin It on Pinterest

Share This