LCase, LCase$ Functions

Named Arguments

No

Syntax

LCase(string)

string

Use: Required

Data Type: String

A valid string expression.

Return Value

LCase$ returns a String, and LCase returns a variant of subtype String.

Description

Converts a string to lowercase.

Rules at a Glance

  • LCase affects only uppercase letters; all other characters in string are unaffected.

  • LCase returns Null if string contains a Null.

Programming Tips and Gotchas

As with all string functions for which two variations are available (one suffixed with the $ sign and one without a $), the $ version returns a String data type, while the plain version returns a variant of subtype String.

See Also

UCase Function

Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.