Microsoft Excel – Text Functions – LOWER, PROPER and UPPER formulas

Microsoft Excel provides set of Text Functions to alter the given text to lowercase, uppercase and capitalize of each word. In this Article, we will discuss the set of functions to be used to convert the text to lower, upper and capitalize.

All these functions takes text as an argument. We can give text directly as an argument or cell reference or another formula which returns the text value.

You can pass numeric values also to these functions, but there will be NO effect in the result, as numeric values do not have any lower and upper variations.

LOWER function

LOWER function is used to covert all characters in the given text to lowercase letters.

FormulaResult
=LOWER(“Apple”)apple
=LOWER(123)123

PROPER function

This function is used to capitalize the first character of each word in the given text. And it converts all other characters to lowercase letters.

FormulaResult
=PROPER(“MICROSOFT EXCEL”)Microsoft Excel
=PROPER(“code steps”)Code Steps
=PROPER(123)123

UPPER function

This function will capitalize entire text. That means, it converts all lowercase characters to uppercase characters in the given text.

FormulaResult
=UPPER(“Microsoft Excel 2013”)MICROSOFT EXCEL 2013
=UPPER(123)123

We will discuss more topics in my Upcoming Articles.

🙂 Sahida

Microsoft Excel – Text Functions – LOWER, PROPER and UPPER formulas

Leave a Reply

Your email address will not be published.

Scroll to top