Convert text into lowercase, uppercase or capitalize the first letter in a string.
LOWER(text), UPPER(text), PROPER(text)
Convert the characters in a text string into lowercase, uppercase or capitalize the first letter in a string.
LOWER, UPPER and PROPER syntax requires just the defined value or cell reference to be converted.
LOWER, UPPER or PROPER with a text string.
In the example below, the PROPER and UPPER functions are used to convert characters in text strings within defined cells.
Use the LOWER, UPPER or PROPER function to convert characters in a text string.
LOWER, UPPER or PROPER with a number.
In the example below, the LOWER and PROPER functions are used to convert characters in numbers within defined cells.
Use the LOWER, UPPER or PROPER function to convert characters in a number.
Syntax
The LOWER, UPPER and PROPER function consists of 1 argument:
- text. Required. The text to convert.
- Text can be enclosed in quotation marks (""), can be a formula that returns text or a reference to a cell containing text to convert.
Try it now!
Enter your formula into the grey cells.
Scope
LOWER(), UPPER() and PROPER() can be applied to cell references, text or numbers.
Spaces, numbers and punctuation are unaffected.
|
=LOWER(C3) or =UPPER(C$4) or =PROPER($C$5) |
|
=UPPER("south"&" "&"America") || returns SOUTH AMERICA. |
|
=PROPER("COORDINATES: 48.8584° n, 2.2945° E") || returns Coordinates: 48.8584° N, 2.2945° E. |
Caveats
- The LOWER, UPPER and PROPER functions do not change characters in text that are not letters.
- PROPER will capitalize the first letter in a text string and letters that follow any character other than a letter. All other letters are converted to lowercase.
Functions Category
Fun Fact!
- The coordinates 48.8584° N, 2.2945° E used above are for the Eiffel Tower in Paris, France.