LOWER

Convert string or text to Lowercase in Excel
Convert character to Lowercase

Rational

Change all letters in a text to lowercase.

Description

The Excel LOWER function converts all letters in the text to small ltters. For example, “LOWer” returns “lower”.

Syntax

=LOWER (text)

Parameters

text – The text to convert lowercase.

Return Value

Same text in lower case.

Key Notes

  • The LOWER Function converts a string’s characters to lowercase, and to convert a text uppercase use the Excel UPPER function.
  • The LOWER function accepts the text entered manually.
  • Non-Alphabetical characters are not affected.

Keep Reading Similar Functions:

Converts text to uppercase in Excel

UPPER

The Excel UPPER function converts all letters in the text to uppercase. E.g., “=UPPER(“Hello World”)” returns ” HELLO WORLD”.

Read More »
Capitalizes the first letter of each word in Excel

PROPER

The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.

Read More »