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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.