The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.

---

Supported versions

• All Excel versions

---

Syntax

---

Arguments

text	The text you want converted into lowercase.

---

Examples

Example 1

formula returns “charizard” as text value.

Example 2

formula returns “6 – charizard – fire, flying“. The LOWER function can convert strings from references. It doesn’t affect numbers, spaces, or punctuation.

Download Workbook

---

Tips

• Try UPPER function to convert strings into uppercase.
• Try PROPER function to capitalize the first letter of each word in a text.