Name

LOWER

Synopsis

Use LOWER to convert all of the characters in the specified text string to lowercase. This function does not affect characters in the string that are not letters.

To Calculate

=LOWER(Text)

Example

Figure 18-5 illustrates how to use LOWER to convert all letters in a string to lowercase. You will notice that the function does not change the numeric portion of the string.

Get Excel 2000 in a Nutshell 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.