VBA Len Function: The Len function in VBA returns the number of characters in a supplied string or the number of bytes required to store a supplied variable.

Syntax

Parameter

Expression (required)- This parameter represents the string or variable of which you want to evaluate the length of.

Return

This function returns the number of characters in a supplied string or the number of bytes required to store a supplied variable.

Example 1

Output

21

Excel VBA Len Function

Example 2

Output

0

Excel VBA Len Function

Pin It on Pinterest

Share This