Excel LOWER Function

The Excel LOWER function is used to convert all the letters within a specified string into lowercase format. Those characters that are not letters (numbers) remain unaffected by the function. In addition, if any punctuation is present, it will also remain unaffected.

Formula

The syntax for Excel LOWER function is:

=LOWER (text)

Explanation

The purpose of this function is to convert the text into lowercase. It is a String/Text function and can be used as a part of the cell formula within a worksheet. The parameter of “text” specifies that only text value needs to be converted to lowercase format, excluding numbers and punctuation.

Example

The below example figure shows how Excel LOWER function returns the given values as lowercase values. AS it is clearly evident that the function placed in cell B5 will display the result of:

=LOWER (B5)

The result will be displayed a “basketball

=LOWER (B6)

The result shows that numbers and punctuation remain unaffected, but only text value is converted to lowercase as “tel:12345

=LOWER (B7)

The result will be #hello_world but please be noted that the punctuation remains intact.

More examples can be shown as ALPHABET is converted into “alphabet” and CHICKEN SOUP will be converted to “chicken soup”.

Figure 1. Result

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar