The UPPER, lower and Proper functions in Sheets allow you to change the case of text. For example, from john smith to John Smith or JOHN SMITH.
Proper Function
What it does?
The PROPER function capitalises the first letter in a text string. (i.e. the first letter of each word.) All other letters will be in lowercase. So All Text Will Look A Bit Like This.
Syntax
=PROPER(text)
Text can be a cell reference (A2), enclosed in quotation marks “like this”, or a formula.
Example
Note – Existing capitol letters may be affected (for example a postcode such as NE2 4NB will change to Ne2 4Nb). Numbers, spaces and punctuation are not affected by the PROPER function in Google Sheets.
UPPER Function
What it does?
The UPPER function converts a text string (e.g. a word) to UPPER case. Numbers, spaces and punctuation are not affected.
Syntax
=UPPER(text)
Text can be a cell reference (A2), enclosed in quotation marks “like this”, or a formula.
Example
lower Function
What it does?
The LOWER function converts a text string (e.g. a word) to lower case. Numbers, spaces and punctuation are not affected.
Syntax
=LOWER(text)
Text can be a cell reference (A2), enclosed in quotation marks “like this”, or a formula.
Example
Click on the download button above, if you want to download a copy of the examples used for the lower, UPPER and Proper functions into Sheets.
To return to the resources page, just click here. If you enjoyed reading about the UPPER, lower and Proper functions in Sheets, you may like to look at some other Sheets functions – such as CONCATENATE, MID, LEFT or RIGHT.