To use these functions, choose .
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.
For text, specify the text or the column of text values.
Column | Calculator expression | Result |
---|---|---|
C1 contains "defective" | UPPER(C1) | DEFECTIVE |
C1 contains "DEFECTIVE" | LOWER(C1) | defective |
C1 contains "defective" | PROPER(C1) | Defective |