The LOWER, UPPER and PROPER case-conversion functions in Excel
In the text function group, the text conversion functions in the text are quite necessary and often used when manipulating, processing text and strings.
The following article introduces you to three font conversion functions: LOWER (), UPPER () and PROPER ().
1. LOWER.
Description
The LOWER () function converts all the characters in the text string into lowercase, helping you to reformat the text string.
Syntax
= LOWER (text)
Inside:
text is the text you want to convert to lowercase. Text can be a reference to a text string or a text string.
For example
2. UPPER.
Description
The UPPER () function helps you convert all characters in a text string (text) into uppercase.
Syntax
= UPPER (text)
Inside:
text is a text string you want to convert all characters to uppercase. Text can be a reference to a string or a string.
For example
3. PROPER.
Description
The PROPER () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.
Syntax
= PROPER (text)
Inside:
text is the first string to capitalize and is a required parameter. Text can be a text string, a formula that returns text, or a cell reference to the text string in uppercase.
For example
Thus, when encountering cases that require you to convert the font in a certain style, you can quickly apply these conversion functions appropriately. Good luck!
You should read it
- Save time with these text formatting functions in Microsoft Excel
- How to capitalize the first letter in Excel
- Summary of trigonometric functions in Excel
- How to fix the SUM function doesn't add up in Excel
- How to display 0 in front of a number in Excel
- SEARCH () and SEARCHB () functions in Excel
- Complete financial functions in Excel you should know
- UPPER function in SQL Server
- MS Excel - Lesson 5: Excel formulas and functions
- PROPER function in Excel
- Summary of information functions in Excel
- Comparison functions in Excel - How to use comparison functions and examples using comparison functions
Maybe you are interested
Prevent text message scams with these features and tricks!
10 Free AI Tools to Generate Images from Text
How to restore the old context menu in Windows 11
WinRAR 6.10 beta update fixes Windows 11 context menu bug
How to share text on Chrome as a link
How to Justify Text in Cells on Excel - Adjust Text Spacing