Tip of the Month:  November 2008

Microsoft Excel 2007:  Change the Case of Text

Converts text to uppercase.

=UPPER(text or cell reference of text)

Converts all uppercase letters in a text string to lowercase.

=LOWER(text or cell reference of text)

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter.  Converts all other letters to lowercase letters.

=PROPER(text or cell reference of text)

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas at 472-0585 or rmaltas2@unl.edu.