Excel LOWER Function (4 Practical Examples)

Excel LOWER Function

Excel LOWER Function converts upper case letters in a text string to lowercase. The LOWER Function has only one argument, Text, which can be a text or reference to cell with the text string. LOWER function does not affect numbers, punctuations, and all spaces.

In this section:

---

1. Syntax of LOWER Function
2. Convert uppercase letters to lowercase
3. Create email address with lower case letters
4. Create company email address with names
5. Convert dates to lowercase

---

1. Syntax of LOWER Function:

LOWER(text)

where:

• Text: The text users want to convert to lowercase. LOWER does not change characters in text that are not letters such as space, numbers, and punctuations.

2. Convert letters to lowercase:

To convert letters lowercase, the formula is =LOWER(Text). The formula is D6 is =LOWER(C6).

3. Create email address with lower:

To create email address with names and domain having all the letters in lowercase, the formula is =CONCAT(LOWER(C6),LOWER(D6),”@gmail.com”), which creates the email address changing the letters to lowercase.

4. Create company email address with names:

To create company email with employee names and company domain, the formula is =LOWER(LEFT(C6)&D6)&”@wikitekkee.com”, which returns the email address of employees in column E.

5. Convert dates to LOWERCASE:

To convert date to lowercase, the formula is =LOWER(TEXT(D6, “dd mmm, yy”)), which returns the lowercase date in column E.

More related readings:

1. MS Office Post on LOWER Function
2. Excel LEN Function
3. Excel IFS Function with practical examples
4. How to extract first names from list of names
5. Excel FIND Function
6. Excel FIXED Function
7. Excel ARRAYTOTEXT Function
8. Excel CLEAN Function with practical examples
9. Excel CONCAT Function to join text
10. Excel REPLACE Function to replace text
11. Excel TRIM Function with Practical Examples