Page 107 - Excle-En-V3

To apply the PROPER function, select PROPER from the list, then click OK. The
following menu will appear:

Figure 148: Choosing the PROPER 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 the first letter is converted to an uppercase letter, as shown

in the following figure:

Figure 149: The result of the PROPER function

-To apply the changes to all names, use the AutoFill feature.
2- UPPER function
It converts the text to uppercase letters.
Text. Required. The text you want converted to uppercase. Text can be a

reference or text string.

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