Len

The Len function determines the number of characters in the Str argument. The LenB function determines the number of bytes in the VarName argument.

• The Str argument can be any valid string expression. If Str contains Null, Null is returned.
• The VarName argument can be any valid variable name. If VarName contains Null, Null is returned. If VarName is a Variant, LenB treats it the same as a String and returns the number of characters it contains.

Syntax

Len(Str)

Str:

A string or expression that can represent a valid text value.

Return Value

Returns a Long.

Related Functions

InStr| Left, Left$| Mid| Right

Example

Dim strTest as String

Dim lngStringLength as Long

strTest = "CitectVBA"

lngStringLength = Len(strTest)	' returns 9