Upper, lower, and proper functions

To use these functions, choose Calc > Calculator.

The Upper function converts all letters to uppercase (capital letters). The Lower function converts all letters to lowercase. The Proper function capitalizes the first letter in each word and converts all other characters to lowercase.

Syntax

  • UPPER(text)
  • LOWER(text)
  • PROPER(text)

For text, specify the text or the column of text values.

Examples

Column Calculator expression Result
C1 contains "defective" UPPER(C1) DEFECTIVE
C1 contains "DEFECTIVE" LOWER(C1) defective
C1 contains "defective" PROPER(C1) Defective
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy