lower

 The LOWER function in Excel is used to convert text to lowercase. Below are 10 examples of how you can use the LOWER function, including data and formulas:

Example 1: Basic Usage

Data:
A1: HELLO WORLD

Formula:
=LOWER(A1)

Result:
hello world

---

Example 2: Combining with Other Text

Data:
A1: HELLO
B1: WORLD

Formula:
=LOWER(A1 & " " & B1)

Result:
hello world

---

Example 3: Lowercase in a Sentence

Data:
A1: This Is A TEST Sentence.

Formula:
=LOWER(A1)

Result:
this is a test sentence.

---

Example 4: Lowercase with Concatenation

Data:
A1: First
B1: Last

Formula:
=LOWER(A1 & " " & B1)

Result:
first last

---

Example 5: Lowercase with Numbers

Data:
A1: ABC123

Formula:
=LOWER(A1)

Result:
abc123

---

Example 6: Lowercase with Special Characters

Data:
A1: HELLO!@#

Formula:
=LOWER(A1)

Result:
hello!@#

---

Example 7: Lowercase in a Formula with IF

Data:
A1: YES

Formula:
=IF(A1="YES", LOWER("CONFIRMED"), LOWER("DENIED"))

Result:
confirmed

---

Example 8: Lowercase with TRIM

Data:
A1: HELLO WORLD

Formula:
=LOWER(TRIM(A1))

Result:
hello world

---

Example 9: Lowercase with SUBSTITUTE

Data:
A1: HELLO WORLD

Formula:
=LOWER(SUBSTITUTE(A1, "WORLD", "UNIVERSE"))

Result:
hello universe

---

Example 10: Lowercase with LEFT and RIGHT

Data:
A1: HELLO WORLD

Formula:
=LOWER(LEFT(A1, 5)) & " " & LOWER(RIGHT(A1, 5))

Result:
hello world

---

These examples demonstrate how the LOWER function can be used in various scenarios, including combining it with other functions like TRIM, SUBSTITUTE, LEFT, and RIGHT.