Use Excel’s LOWER function to convert text to lowercase: if the original text is in A2, enter =LOWER(A2) in another cell. The result changes the letter case while leaving the source cell untouched, so you can review the converted text before deciding whether to replace the original.
What the LOWER formula does
LOWER is a built-in Excel text function. It changes uppercase letters in the text it receives to lowercase letters. For example, it can turn a person’s name typed as all caps into a more consistent form, or standardize product labels imported from different systems. It does not need an add-in, macro, or special setting.
The function changes case, not meaning or word structure. It does not translate text, correct spelling, remove punctuation, or decide which words should be capitalized as names. It also does not edit the cell you refer to: Excel displays the converted result in the formula cell. That distinction is useful when the original data must be preserved or checked.
Excel formulas recalculate when their referenced values change. If A2 contains a different name later, a formula referring to A2 will show the lowercase version of the new value. In Microsoft 365 for Windows, the same function is available in Excel for Mac and Excel for the web, although ribbon layout and some keyboard shortcuts can differ between platforms.
Enter the formula and check the result
Suppose A2 contains NORTH RIDGE. With that text in A2, enter this formula in B2:
=LOWER(A2)
B2 displays north ridge. The formula has one input: the text, or a cell reference containing the text, that Excel should convert. The cell reference is usually easier to maintain than typing a text value directly into a formula, because you can change the source data without rewriting the formula.
To try it in a worksheet:
- Type a sample value, such as NORTH RIDGE, into A2.
- Select B2 and enter
=LOWER(A2). - Press Enter and check that B2 displays north ridge.
If you are using Excel for the web, the entry process is essentially the same: select a cell, type the formula, and press Enter. You can also start a formula by typing an equals sign in the formula bar or directly in a cell. There is no need to select a casing option from the ribbon; this is a worksheet formula.
Convert a whole column of text
For a list, put the source values in one column and the formula beside the first value. For example, with names in A2:A20, enter =LOWER(A2) in B2. After confirming the result, copy the formula down through B20. Each copied formula adjusts its reference to the row beside it: B3 refers to A3, B4 refers to A4, and so on.
You can fill the formula down by dragging the small square at the bottom-right corner of the selected formula cell, or by copying the cell and pasting it into the remaining destination cells. If the adjacent source column has a continuous list of values, double-clicking that small square often fills down to the end of the neighboring data. Check the last row afterward, especially if the neighboring column contains blank cells.
In Microsoft 365, you can also use a dynamic-array formula for a range. With source text in A2:A5 and the destination cells below B2 empty, enter =LOWER(A2:A5) in B2. Excel returns lowercase results down the cells below B2. This is called spilling. If something is already in a cell where the results need to spill, Excel reports a spill error; clear the obstructing cell or use the fill-down method. If you prefer a formula copied row by row, the single-cell version works well in older Excel versions too.
What changes—and what stays the same
LOWER changes letter case in text. Spaces between words and punctuation remain in place. For example, with A2 containing Hello, World!, the formula =LOWER(A2) returns hello, world! The comma, exclamation mark, and spacing are not removed. That makes the function suitable for case standardization without altering the rest of a label.
It does not remove extra spaces at the beginning or end of a value. If A2 contains spaces before or after a name, those spaces remain in the result. If you also want to remove excess ordinary spaces, use =LOWER(TRIM(A2)). This assumes the source text is in A2; TRIM removes leading and trailing spaces and reduces repeated spaces between words to single spaces before LOWER converts the letters. Some imported nonbreaking spaces are different characters and may not be removed by TRIM alone.
Case conversion can also change how text looks without changing its underlying identity for every Excel task. For example, Excel’s standard text comparisons and many lookup operations are not case-sensitive. Lowercasing a list can still be helpful for readable, consistent output, but it is not automatically necessary to make ordinary text matches work. If capitalization carries meaning in a particular external system or identifier, check that system’s requirements before standardizing it.
Keep the formula or replace it with text
There are two useful ways to finish. Keep the formulas if you want the lowercase results to update whenever the original values change. Use a separate output column and give it a clear heading, such as Lowercase Name. This approach preserves the source and lets you compare the two columns for unexpected changes.
If the lowercase results are final and you want to remove the formulas, copy the result cells, then use Home > Paste > Values to paste the displayed text over those same cells or into another destination. In Excel for Mac, the Paste options are also available from the Home tab, although the arrangement can vary with the ribbon layout. Pasting values creates fixed text rather than formulas, so later edits to the source column will no longer update those cells.
Before replacing source data, make a copy of the original column or workbook if you may need to recover the original capitalization. A safe workflow is to generate the results in a new column, inspect them, and only then decide whether to paste values over the source. Pasting values over a formula column is different from deleting the formulas: it keeps the displayed results as ordinary cell contents.
Use LOWER with imported or inconsistent data
Data copied from emails, websites, exports, or other spreadsheets may have inconsistent capitalization. A helper column using =LOWER(A2), assuming the imported text is in A2, can make labels uniform before you sort, print, or prepare a report. It is especially handy when the same category appears as OFFICE, Office, and office. The results become consistently lowercase, making visual review easier.
For more than one cleanup task, combine functions carefully. With source text in A2, =LOWER(TRIM(A2)) lowercases the text and cleans ordinary extra spaces. It will not remove punctuation or correct misspelled words. If a value contains unwanted characters from an import, identify those characters first and choose a specific cleanup method rather than assuming LOWER will remove them.
Numbers need a little care. LOWER is intended to change text, not to format numeric values. If a cell contains a number stored as a number, applying a text function may produce a text result, which can behave differently from a numeric value in calculations or sorting. For codes such as 007A, store the code as text if its leading zeros are significant. Converting the letters to lowercase does not restore zeros already lost because Excel interpreted an entry as a number.
Common problems and how to fix them
- The formula appears as text. Check that the cell is not formatted as Text, and check for an apostrophe or space before the equals sign. Change the cell format to General if needed, then re-enter the formula.
- The result has not changed. Confirm that the formula points to the intended source cell. LOWER does not change text that is already lowercase, and it leaves numbers and punctuation alone.
- The formula shows an error or an unexpected value. Check that the reference is valid and that the source contains the value you expect. If the source formula itself returns an error, LOWER cannot turn that error into ordinary text.
- The result will not spill. For a range formula, make sure the destination cells below the formula cell are empty and not merged with other cells. Alternatively, use one formula per row and fill it down.
- Spaces are still present. LOWER changes case only. If extra ordinary spaces are the issue, combine it with TRIM; if the data came from an external source, inspect for nonbreaking spaces or other invisible characters.
One common misconception is that LOWER changes the capitalization of the source cell itself. It does not: the formula returns a result elsewhere. Another is that Excel requires text to be lowercase before it can be searched or matched. Many standard Excel text comparisons are case-insensitive, so LOWER is usually chosen for consistent display or standardized output, not as a universal requirement for matching.
LOWER compared with UPPER and PROPER
Excel also provides UPPER and PROPER for different capitalization needs. UPPER changes letters to uppercase. PROPER capitalizes the first letter of each word and converts other letters in those words to lowercase. These functions do not understand every name or title convention, so PROPER may produce an unwanted result for initials, acronyms, or names with unusual capitalization.
Choose the function based on the required output, not just on what the source currently looks like. Use LOWER when every letter should be lowercase, UPPER when every letter should be uppercase, and PROPER when a basic first-letter-of-each-word style is appropriate. For a specific brand name or a list of exceptions, review the output rather than treating automatic capitalization as editorial judgment.
Frequently Asked Questions
What is the Excel formula for lowercase?
Use =LOWER(A2) when the text to convert is in A2. Enter it in a different cell to show the lowercase result while leaving A2 unchanged.
Can I convert an entire column to lowercase?
Yes. Enter the formula beside the first source value, then fill it down. In Microsoft 365, a range formula can also spill results for a source range when the cells below the formula are empty.
Does LOWER change the original text?
No. It returns converted text in the cell containing the formula. To make the result permanent, copy the results and use Home > Paste > Values; keep a copy first if you may need the original capitalization.
How do I lowercase text and remove extra spaces?
With the original text in A2, use =LOWER(TRIM(A2)). It converts the letters and cleans ordinary extra spaces, but it may not remove every special invisible character from imported text.
Is LOWER case-sensitive, and do I need it for lookups?
LOWER explicitly changes the displayed text to lowercase. Many standard Excel comparisons and lookup operations do not distinguish uppercase from lowercase, so conversion is often for consistent presentation rather than a requirement for matching.
Related
- Excel Very Slow Loading Data? Causes and Fixes
- How to Calculate VaR 99 in Excel
- Excel Vertical Text: How to Rotate Text in Cells
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- DAX Formula to Concatenate Text in Power BIIn Power BI, use the DAX & operator to join text: Customers[FirstName] & " " & Customers[LastName]. Use…
- How to Create Rules in Outlook to Sort Email AutomaticallyTo create a rule in Outlook, open Settings > Mail > Rules in new Outlook or Outlook on…
- How to Find an Average in Excel With AVERAGE FunctionTo find the average in Excel, enter the AVERAGE function in an empty cell and point it to…
- Power Query Fuzzy Match: How It Works and How to Use ItYes. Power Query can fuzzy-match text when you merge queries, helping connect values that are similar but not…
- COUNTIF Examples: Formulas for Common Spreadsheet TasksUse Excel’s COUNTIF function to count cells in one range that meet one condition: =COUNTIF(range,criteria). For example, it…
- Excel Text Unique Values: Extract, Count, and CompareYes. In Excel for Microsoft 365, use UNIQUE to return a list of distinct text values from a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.