Tip of the Week
Today’s Tip of the Week is in Microsoft Excel:
Need to change uppercase or lowercase text to the proper case?
Example of text: susannah groves
Using the proper case would produce: Susannah Groves
The syntax for this function is =proper(cell address).
For example, let’s say my name is in cell A1. Your function in cell A2 would be =proper(A1). Our Excel pros can also use this syntax but replace the word to create an upper text function or lower text function as well by replacing the word “proper” with either “lower” or “upper.”
One word to the wise: if you use a proper name that begins with “Mc,” you will not be able to capitalize the following letter. For example, “mcdonald” would produce “Mcdonald,” NOT “McDonald.” This is because the proper case function will only capitalize the first letter of the word.
