LOWER Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Returns a string converted to lowercase.

LOWER(expression)

Parameters

Name

Required/Optional

Data Type

Description

expression

Required

Varies

A string, a cell reference, or an expression; the result is converted to a string which is then converted to lowercase.

Return Value

String

The case conversion is locale-specific, based on the current user settings.

LOWER("mIxEd CAse")

Returns "mixed case".

Show: