The Excel function to convert text to lowercase is LOWER. For example, =LOWER("HELLO") returns hello, and you can apply it to any cell reference like =LOWER(A1) to lowercase the contents of cell A1.
What LOWER Does and Its Syntax
LOWER is one of Excel’s text functions, alongside UPPER (converts to uppercase) and PROPER (capitalizes the first letter of each word). Its syntax is simple:
=LOWER(text)
The text argument can be a direct string in quotes, a cell reference, or a formula that returns text. For instance, with “John Smith” in cell A1, =LOWER(A1) gives john smith. The function only affects letters; numbers, punctuation, and spaces are left unchanged. It works in all modern versions of Excel, including Excel for Microsoft 365, Excel 2021, 2019, 2016, and earlier versions, as well as Excel for Mac and Excel for the web.
How to Use LOWER in a Formula
To convert text in a cell to lowercase, follow these steps:
- Click on an empty cell where you want the lowercase text to appear.
- Type
=LOWER(. - Click on the cell containing the text you want to convert, or type the cell reference (e.g.,
A1). - Close the parenthesis and press Enter.
For example, if cell A1 contains MICROSOFT EXCEL, entering =LOWER(A1) in B1 returns microsoft excel. You can then copy the formula down a column to convert multiple cells. If you want to replace the original text with the lowercase version, copy the formula results, then use Paste Special > Values to overwrite the originals.
Common Use Cases and Examples
Lowercasing text is often needed when cleaning data for consistency, especially when you’re about to use functions like VLOOKUP or MATCH that are case-insensitive by default but may behave differently with exact matches. Here are a few practical examples:
- Cleaning imported data: If you import a list of email addresses that have mixed case,
=LOWER(A2)normalizes them to lowercase. - Standardizing product codes: Convert all SKUs to lowercase for easier comparison.
- Combining with other functions: Use
=LOWER(TRIM(A1))to remove extra spaces and lowercase in one step. - Conditional formatting: You can create a rule that highlights cells where
=LOWER(A1)="urgent"to catch any case variation.
For example, with a list of names in A2:A10, putting =LOWER(A2) in B2 and dragging down gives all lowercase names. If you need to extract a lowercase substring, combine with LEFT, RIGHT, or MID: =LOWER(LEFT(A1,5)) lowercases the first five characters.
What LOWER Does NOT Do
Many users expect LOWER to handle more than simple case conversion. It does not:
- Remove spaces or punctuation: Use
TRIMandSUBSTITUTEfor that. - Convert accented characters to unaccented ones: LOWER only changes case; it doesn’t strip diacritics. For example,
=LOWER("ÉLAN")returnsélan, notelan. To remove accents, you’d need a more complex formula or VBA. - Change text in place: LOWER returns a new value; it doesn’t modify the original cell unless you overwrite it manually.
- Work with arrays of text directly: You can use it on a range in an array formula, but that’s not its typical use.
Alternatives: UPPER, PROPER, and Flash Fill
Depending on your goal, you might choose a different function:
=UPPER(A1)converts to uppercase.=PROPER(A1)capitalizes the first letter of each word, e.g.,john smithbecomesJohn Smith.- Flash Fill (Data > Flash Fill, or Ctrl+E on Windows, Cmd+E on Mac) can convert case without formulas. Type the lowercase version in the adjacent column, then press Ctrl+E to auto-fill the rest. This is handy for one-off conversions.
Flash Fill is available in Excel 2013 and later, including Microsoft 365. It works by recognizing patterns, so it’s great for irregular data, but it doesn’t update automatically if the source data changes—unlike a formula.
Using LOWER with Other Functions
LOWER is often nested inside other functions to ensure consistent comparisons. For example, to check if a cell contains “apple” regardless of case, you could use:
=IF(ISNUMBER(SEARCH("apple",LOWER(A1))),"Yes","No")
With “Apple” in A1, LOWER(A1) becomes “apple”, and SEARCH finds it. Similarly, to create a unique ID from a name, you might use =LOWER(LEFT(A1,1)&B1). Remember that SEARCH is case-insensitive anyway, but FIND is case-sensitive, so using LOWER with FIND can force case-insensitivity: =IF(ISNUMBER(FIND("apple",LOWER(A1))),"Yes","No").
For data validation, you can use LOWER in a custom rule to reject uppercase entries. For example, select the range, go to Data > Data Validation > Settings, choose Custom, and enter =LOWER(A1)=A1. This ensures only lowercase text is entered.
Frequently Asked Questions
Does LOWER work with numbers?
No, LOWER only affects letters. If you pass a number like =LOWER(123), it returns 123 unchanged. If you pass a cell containing a number, it returns that number as text, but without any case change.
How do I lowercase an entire column without typing a formula for each cell?
Enter the formula in the first cell, then double-click the fill handle (the small square at the bottom-right of the cell) to copy it down the column. Alternatively, use Flash Fill as described above.
Can I use LOWER in conditional formatting to highlight lowercase cells?
Yes. In the conditional formatting rule, use a formula like =LOWER(A1)=A1 to highlight cells that are already lowercase. Note that this will also highlight empty cells, so you may want to add =AND(A1<>"",LOWER(A1)=A1).
Why doesn’t LOWER change accented characters?
LOWER only changes the case of letters; it does not remove diacritical marks. For example, =LOWER("É") returns é (lowercase é), but not e. To remove accents, you need a helper column with a formula that substitutes each accented character, or use a VBA macro.
Is there a way to lowercase text in place without formulas?
Yes, use Flash Fill. Type the lowercase version in the adjacent column, then press Ctrl+E (Windows) or Cmd+E (Mac). Excel will fill the rest based on the pattern. This is a manual method and won’t update automatically if the source changes.
Does LOWER work in Excel for the web?
Yes, LOWER is available in Excel for the web. The syntax is identical, and you can use it in formulas just like in the desktop version. Flash Fill is not available in Excel for the web, so you’d use formulas there.
Related
- Excel Conditional Formatting for Past Dates
- Excel Conditional Formatting Duplicate Rows: Full Guide
- Excel Conditional Formatting Date Occurring: How To
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Snowflake LENGTH Function: Count String CharactersIn Snowflake, use LENGTH(string) to return the number of characters in a string; LEN(string) is an alias. For…
- VLOOKUP Examples for Multiple Sheets in ExcelTo look up a value on another worksheet, use VLOOKUP with that sheet’s range, such as =VLOOKUP(A2,Products!$A$2:$C$100,2,FALSE). To…
- SUBTOTAL Formula Shortcut: Insert It Quickly in ExcelIn Excel for Microsoft 365 on Windows, press Alt+= to run AutoSum, but this is not a dedicated…
- Excel ABS Function: How to Return a Positive ValueTo turn a negative number into a positive one in Excel, use the ABS function: it returns the…
- CATIA Split Function: How It Cuts Parts and SurfacesIn CATIA, the Split function cuts a solid or surface with a selected plane or other cutting element…
- Excel MAX IF: Max with Criteria ExplainedThe direct answer: use the array formula =MAX(IF(range=criteria, max_range)) entered with Ctrl+Shift+Enter in older Excel, or the dynamic-array…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.