Page 108 - Excle-En-V3

To write the function, apply the same steps of the PROPER function, but choose
UPPER instead of PROPER.

Figure 150: Choosing the UPPER function

- Click on the arrow that appears, then choose the first name (mohamed), then
click Enter on the keyboard, then OK.

You will notice that all lowercase letters are converted to uppercase letters, as
shown in the following figure:

Figure 151: The result of the UPPER function

3- LOWER function

It converts all uppercase letters in a text string to lowercase letters.
Text. Required. The text you want to convert to lowercase. LOWER does not
change characters in the text that are not letters.
To write the function, apply the same steps of the PROPER function, but choose
LOWER instead of PROPER.

100 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024