To change all-caps text to lowercase in Excel, put the original text in A2:A6 and enter =LOWER(A2) in B2. Fill the formula down, then copy the results and paste them back over the originals as values if you want to replace the source text. The LOWER function is the dependable option for converting a whole range at once.
What You’ll Need
- An Excel workbook with the text you want to convert. The steps below are for Microsoft Excel for Microsoft 365 on Windows; LOWER is also available in other modern Excel versions.
- An empty helper column beside the text, or another blank range where the converted results can go temporarily.
- A saved copy of the workbook if the text is important. The formula method keeps the original cells intact until you choose to replace them.
Step-by-Step
- Find and check the source range. Identify the cells containing the uppercase text, such as a list of names in A2:A100. Check whether the first row is a heading so you do not convert or overwrite it by mistake. If the column contains unrelated information, plan to use only the cells that need changing.
- Choose a blank helper column. If your text is in column A, use an empty column such as B. Add a heading such as Lowercase in B1 if that helps you keep track of the temporary results. Do not put the formula in the source cell itself: a formula that refers to its own cell would create a circular reference.
- Enter the LOWER formula in the first result row. With the original text in A2:A6 and the result column starting at B2, enter
=LOWER(A2)in B2 and press Enter. For example, if A2 contains MAYA CHEN, B2 displays maya chen. If A3 contains ORDER #AB-17, B3 displays order #ab-17; the number sign, hyphen, and digits remain as they were. - Fill the formula down the range. Select B2, then drag the small square at the bottom-right corner of the selection down to the last row of your source data. Alternatively, if the adjacent source cells are continuously filled, double-click that square to fill down alongside them. You can also select B2 through the last destination cell and press Ctrl+D on Windows. Excel adjusts the reference for each row, so the next formula refers to A3, then A4, and so on.
- Review the converted results. Scan several rows, including the first and last, and compare them with the source. Check that the correct rows were included and that punctuation, spaces, numbers, and any mixed-case text look right. LOWER changes uppercase letters to lowercase; it does not remove leading or trailing spaces, correct spelling, or alter the underlying value in column A.
- Keep both columns or replace the source values. If you want the original text preserved, leave the helper column in place and use it as your lowercase version. If you want the original cells changed, select and copy the completed results in column B, select the first corresponding source cell in A, and choose Home > Paste > Paste Special > Values. This pastes the displayed text rather than formulas that point back to the helper column.
- Confirm the replacement before cleaning up. Check a few cells in column A after pasting. If the values look correct, delete the temporary helper column if you no longer need it. If the pasted values are wrong, use Ctrl+Z immediately to undo the paste, while it is still the most recent action, then check the selected ranges and try again.
The layout in the example is only illustrative. If your text starts in a different cell, use that cell reference in the first formula, then fill down from there. For example, with text in D5:D20, the first helper formula belongs beside the first item and should refer to D5. Keep the source range and destination range the same height so each converted result stays aligned with its original.
Common Mistakes
Typing the formula into the source cell. A helper formula needs to refer to the original cell from a separate cell. Entering a formula that refers to itself can produce a circular reference warning, while overwriting the source text removes the content you meant to convert. Use a blank column, verify the output, and only replace the source after copying the results as values.
Copying formulas instead of values over the source. If you copy the helper formulas and paste them into the original range, the formulas may refer to cells that are then overwritten or moved. The output can turn into errors or unexpected text. Use Paste Special > Values for the replacement step. If you want a live lowercase version that updates when the original changes, keep the formulas in the separate helper column instead.
Including a heading or selecting the wrong number of rows. Filling too far can create extra blank results, and including a heading may turn it into lowercase. Filling too short leaves some entries unchanged. Compare the first and last selected rows with the source list before pasting anything over it.
Expecting LOWER to do more than change case. LOWER is not a spell checker, a trim function, or a title-case tool. It does not remove spaces or fix inconsistent names. It also does not change numbers or punctuation. If text contains extra spaces, those spaces remain in the result, so address that separately if needed.
Tips
Use Flash Fill for a quick one-off conversion. If you prefer not to keep a formula, type the lowercase version of the first entry in an adjacent column. Select the next cell in that column and use Data > Flash Fill, or press Ctrl+E in Excel for Microsoft 365 on Windows. Excel tries to detect the pattern and fill the remaining rows. Review the results: Flash Fill produces entries rather than formulas, and it may not infer the pattern correctly for irregular data. On a Mac, look for Flash Fill on the Data tab; the available shortcut can differ by keyboard and Excel version.
Turn formulas into fixed results when appropriate. A LOWER formula updates if its referenced source cell changes. That is useful when the source is still being edited. If you need a fixed lowercase list, copy the results and paste values into a new location or over the source only after checking the conversion. This prevents later changes to the source from altering a list that is supposed to stay as it is.
Use a table carefully. If your source is an Excel table, putting a formula in the adjacent table column often fills it through the table automatically. Give the new column a clear heading, and check that the formula has populated every data row. To replace the original table column, paste values into its data cells, not into the heading, and make sure the two columns have matching row order.
Keep a backup before a large replacement. The helper-column approach is reversible while the originals remain untouched. After you paste values over the original range, ordinary undo may no longer be available once other actions have been taken or the workbook has been closed. Save a separate copy first when converting a large or important dataset.
Troubleshooting
The formula appears as text instead of returning lowercase. The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell format to General using Home > Number Format > General, then re-enter the formula. Selecting the cell, pressing F2, and then pressing Enter can also prompt Excel to evaluate a formula that was entered while the cell was formatted as text.
The output is blank or shows an error. Check that the formula refers to the intended source cell and that the source has not been deleted or moved. If the referenced cell is blank, LOWER returns a blank result. If you see a reference error, undo any recent move or deletion and rebuild the helper formula beside the correct source row.
Only some rows converted. The fill handle may have stopped early, especially if the neighboring column contains blank cells. Select the first formula cell and fill down to the exact last row yourself, or select the full destination range and use Ctrl+D on Windows. Inspect the bottom of the range before copying results back.
Flash Fill leaves entries unchanged or guesses incorrectly. Undo the Flash Fill result, provide a clearer example in the first output cell, and run Data > Flash Fill again. For a consistent conversion across a large or changing range, use LOWER instead; formulas follow the row references predictably and are easier to audit.
The original values changed in an unexpected way. If you have just pasted, press Ctrl+Z on Windows to undo. Then confirm that the copied results cover exactly the intended rows and that the paste option is Values. On Mac, use Command+Z to undo. If more actions have happened since the paste, restore the saved copy or use version history if it is available for the workbook.
Frequently Asked Questions
Does Excel have a button to change text to lowercase?
Excel for Windows does not have a dedicated Change Case button like some other Office apps. Use the LOWER function in a helper column, or try Flash Fill for a quick one-off conversion and check its results.
Can I change the original cells without keeping a formula?
Yes. Convert the text in a helper column, copy the finished results, then use Home > Paste > Paste Special > Values over the corresponding source cells. Check the pasted range before deleting the helper column.
Will LOWER change numbers, punctuation, or spaces?
No. LOWER changes uppercase letters to lowercase. Numbers and punctuation stay the same, and spaces are not removed. If you also need to clean extra spaces or standardize other parts of the text, handle those as separate steps.
Can I use LOWER on a whole column?
Yes, but it is usually clearer to fill the formula only through the rows that contain data. In a table, a formula in the adjacent column may automatically fill down as a calculated column. Check that it has not included headings or unrelated rows.
Will the lowercase results update when I edit the original?
They will if they are still formulas referring to the source cells. If you paste the results as values, they become fixed text and will not update when the original data changes.
Does this work in Excel for Mac or Excel for the web?
Yes. LOWER works in Excel for Mac and Excel for the web as well as Excel for Windows. Ribbon placement and keyboard shortcuts can differ, so use the Paste Special values option shown in the interface if the Windows shortcut or menu layout does not match.
Related
- How to Paste in Excel and Keep Formatting
- How to Paste in Excel Only Visible Cells Without Hidden Rows
- Paste in a Filtered List in Excel Without Hidden Rows
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Concatenate in Excel and Keep Leading ZerosTo concatenate values in Excel and keep leading zeros, format the value with TEXT inside the formula before…
- Excel MIN Function Examples: Find the Smallest ValueExcel’s MIN function returns the smallest number in a set of values. For example, with scores in B2:B8,…
- Excel Sort and Filter Shortcuts: A Practical GuideIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a…
- Excel IFS Function for Data Analysis: Rules and ExamplesExcel’s IFS function tests conditions in order and returns the result for the first condition that is TRUE.…
- Sort Excel by Highlighted Rows: Step-by-StepYes. In Excel for Microsoft 365 on Windows, select the entire table, open Data > Sort, set Sort…
- XLOOKUP Match Mode Examples: Exact and ApproximateXLOOKUP’s match_mode argument controls what counts as a match: use 0 for an exact match, -1 for an…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.