How to change text case in excel
1. LOWER : Converts all uppercase letters in a text string to lowercase.
Syntax
LOWER(text)
Text is the text you want to convert to lowercase. LOWER does not change characters in text that are not letters.
2. PROPER : Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Syntax
PROPER(text)
Text is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
3. UPPER : Converts text to uppercase.
Syntax
UPPER(text)
Text is the text you want converted to uppercase. Text can be a reference or text string.
Regards
MsExcel Classes Team
~-~~-~~~-~~-~
Please watch: "How to prepare Financial Statements in excel in hindi"
• How to prepare Financial Statements in exc...
~-~~-~~~-~~-~