Microsoft Excel Functions & Formulas

Use the LOWER function to convert text from

uppercase to lowercase

To convert all letters to lowercase in a text string, use the LOWER

function. This function has the following syntax:

LOWER(text)

text: Text to be converted to all lowercase letters. The text can

be either a reference or a text string.

4

To convert a text string to lowercase:

1. In cells A2:A8 type any text in uppercase letters.

2. Select cells B2:B8 and type the following formula:

=LOWER(A2).

3. Press <Ctrl+Enter>.

76

Chapter 3

Figure 3-17