The LOWER function converts every uppercase letter in a text value to lowercase, leaving numbers, spaces and punctuation unchanged. It is the quick way to standardise names, emails and codes so lookups, comparisons and reports behave consistently.
=LOWER(text)What does LOWER do?
LOWER is one of Excel's text functions. You give it a piece of text, and it returns that same text with all capital letters turned into small letters. Numbers, spaces, punctuation and symbols are left exactly as they were, so LOWER("Order AB-123") becomes order ab-123.
Why does this matter? Excel treats text as case-sensitive in many situations. VLOOKUP, MATCH, COUNTIF and IF comparisons can fail when one value is "North" and another is "north". Data pasted from other systems often arrives in mixed case. LOWER gives you a predictable, uniform version of the text to compare, match or display.
A common real situation: you export a customer list where some email addresses are typed in capitals and some in lowercase. Before you remove duplicates or match against another list, you run LOWER over the email column. Now every address is lowercase, and your matching works reliably.
When to use LOWER
- Standardising email addresses before removing duplicates or matching lists.
- Making case-insensitive comparisons in
IF,COUNTIForMATCH. - Cleaning product codes or SKUs that arrive in mixed case.
- Preparing usernames for systems that require lowercase logins.
- Formatting text for display in reports where lowercase looks cleaner.
- Normalising data imported from other systems before analysis.
LOWER syntax
=LOWER(text)| Argument | Required? | What to enter |
|---|---|---|
text | Required | The text you want to convert to lowercase. It can be a cell reference, a text string in quotes, or a formula that returns text. Example: =LOWER(A2) or =LOWER("HELLO"). |
What it returns: A text string with all uppercase letters converted to lowercase. Numbers, spaces, punctuation and symbols are unchanged.
LOWER examples
1 Convert a single name to lowercase
The goal is to see how LOWER handles a simple mixed-case name. The formula =LOWER(A2) takes the value in cell A2, "Alice SMITH", and converts every capital letter to lowercase. The result is "alice smith". Notice that the space is kept and only the letters change.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | |||
| 2 | Alice SMITH | alice smith | ||
| 3 | BOB Jones | |||
| 4 | carol white | |||
| 5 |
2 Clean email addresses for duplicate checking
Email addresses are often typed with inconsistent capitalisation. The formula =LOWER(A2) converts the address in A2 to all lowercase. This makes it easier to spot duplicates or match against another list. The result for "John.Doe@Example.COM" is "john.doe@example.com".
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | John.Doe@Example.COM | john.doe@example.com | ||
| 3 | jane.smith@EXAMPLE.com | |||
| 4 | MIKE@example.com | |||
| 5 |
3 Standardise product codes
Product codes from different suppliers may use different cases. The formula =LOWER(A2) converts the code in A2 to lowercase. This helps when you need to match codes across systems that expect a specific case. For "AB-123-XY", the result is "ab-123-xy".
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product Code | |||
| 2 | AB-123-XY | ab-123-xy | ||
| 3 | cd-456-zw | |||
| 4 | EF-789-UV | |||
| 5 |
4 Make a case-insensitive comparison
Suppose you want to check if the department in A2 is "sales" regardless of case. The formula =LOWER(A2)="sales" converts A2 to lowercase and compares it to the lowercase word "sales". It returns TRUE if they match, FALSE otherwise. For "SALES", the result is TRUE.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Department | |||
| 2 | SALES | TRUE | ||
| 3 | Marketing | |||
| 4 | sales | |||
| 5 |
5 Create a lowercase username from a full name
You need to generate a username from a full name. The formula =LOWER(LEFT(A2,1)&B2) takes the first letter of the first name in A2, joins it with the last name in B2, and converts the whole thing to lowercase. For "John" and "Smith", it produces "jsmith". This is a common way to build login IDs.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | First Name | Last Name | |||
| 2 | John | Smith | jsmith | ||
| 3 | Mary | Johnson | |||
| 4 | Peter | Brown | |||
| 5 |
Common LOWER errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The text argument refers to a cell that contains an error value, or you passed a value that Excel cannot treat as text (such as a date serial number without conversion). | Check the source cell for errors. If you need to convert a number or date, wrap it in TEXT first, for example =LOWER(TEXT(A2,"0")). |
| #NAME? | The function name is misspelled, for example =LOWERR(A2). | Use the correct spelling LOWER. |
| Wrong result (no change) | The cell contains a formula that returns text, but you expected LOWER to change the original cell. LOWER returns a new value; it does not modify the source. | Use the result cell, or copy the result and paste as values over the original if you need to replace it. |
| #VALUE! with array | In older Excel versions, LOWER does not accept an array of values directly without dynamic arrays. | Enter the formula in a single cell and copy down, or use a version of Excel that supports dynamic arrays. |
Tips for using LOWER
- Use LOWER together with TRIM to clean up extra spaces and standardise case in one step:
=LOWER(TRIM(A2)). - To compare text without case sensitivity, wrap both sides in LOWER:
=LOWER(A2)=LOWER(B2). - LOWER only affects letters; it does not change numbers, so it is safe on codes that contain digits.
- If you need to change the original data, copy the LOWER results and use Paste Special > Values to replace the source.
- Combine LOWER with LEFT, RIGHT or MID to build standardised usernames or codes.
- Remember that LOWER is not the same as PROPER (which capitalises each word) or UPPER (which makes everything uppercase).
Frequently asked questions
Does LOWER change numbers or punctuation?
No. LOWER only converts uppercase letters to lowercase. Numbers, spaces, punctuation and symbols remain exactly as they are.
Can I use LOWER on a range of cells at once?
In Excel with dynamic arrays, you can enter =LOWER(A2:A10) and it will spill results. In older versions, you need to enter the formula in one cell and copy it down.
How is LOWER different from PROPER?
LOWER makes all letters lowercase. PROPER capitalises the first letter of each word and makes the rest lowercase. For example, LOWER("john smith") gives "john smith", while PROPER("john smith") gives "John Smith".
Does LOWER work on text in other languages?
Yes, LOWER works with Unicode characters and will convert letters with diacritics (like É to é) according to your system settings.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. LOWER reference