Changing The Case Of Text


Excel provides three handy functions to change the case of text:
 UPPER: Converts the text to ALL UPPERCASE.
 LOWER: Converts the text to all lowercase.
 PROPER: Converts the text to Proper Case. (The First Letter In Each Word Is Capitalized.)
These functions are quite straightforward. The formula that follows, for example, converts the
text in cell A1 to proper case. If cell A1 contained the text MR. JOHN Q. PUBLIC, the formula would



.
=PROPER(A1)





These functions operate only on alphabetic characters; they ignore all other characters and return
them unchanged.