The functions UPPER, LOWER, and PROPER, return capitalized text based on a quoted text string or text in another cell.
-
The syntax is =UPPER(text), where text is a cell or text string you want to change.=UPPER(A1) changes all lowercase text in A1 to UPPERCASE.
=LOWER(A1) changes all UPPERCASE text in A1 to lowercase.
=PROPER(A1) capitalizes the first letter of words from cell A1 to title or Proper Case. -
To capitalize an explicit text string, you must quote it in the formula. For example, =UPPER("end of document") returns END OF DOCUMENT.
The functions UPPER, LOWER, and PROPER, return capitalized text based on a quoted text string or text in another cell.
-
The syntax is =UPPER(text), where text is a cell or text string you want to change.=UPPER(A1) changes all lowercase text in A1 to UPPERCASE.
=LOWER(A1) changes all UPPERCASE text in A1 to lowercase.
=PROPER(A1) capitalizes the first letter of words from cell A1 to title or Proper Case. -
To capitalize an explicit text string, you must quote it in the formula. For example, =UPPER("end of document") returns END OF DOCUMENT.