To change text that is already in all caps to lowercase in Excel, enter =LOWER(A2) in a blank cell beside it, then fill the formula down. The Caps Lock key only affects what you type; it does not change existing cell contents. Once the converted text looks right, copy it and paste values if you want to replace the original text.
What You’ll Need
- An Excel workbook containing the uppercase text you want to convert.
- A blank column or another empty area for the lowercase results. Keep the source cells until you have checked the conversion.
- Microsoft Excel for Microsoft 365 on Windows for the steps below. The LOWER formula also works in Excel for Mac and Excel for the web; notes about those versions are included where useful.
Step-by-Step
- Check where your text is. Identify the cells that contain the capitalized text, and note the first cell address. For example, a list of names might be in A2:A20, with a header in A1. Make sure the column beside the list is empty so the output will not overwrite other information. If there are blank rows within the list, the formula can still be filled down, but check the corresponding results afterward.
- Choose an output cell. Click the first empty cell beside the first source entry. With source text in A2:A20, click B2. Do not put the formula in A2: it would replace the source text and create a circular reference if it refers back to A2. Keeping the original and converted text in separate columns makes it easier to spot errors and recover the original if needed.
- Enter the lowercase formula. With the source text in A2:A20 and the first result going in B2, type
=LOWER(A2)in B2 and press Enter. LOWER converts letters in the referenced cell to lowercase. For example, if A2 contains MARIA GARCIA, B2 displays maria garcia. It leaves numbers and punctuation as they are, so an entry such as ORDER-42 becomes order-42. Leading or trailing spaces are not removed by LOWER. - Fill the formula down the list. Select B2 again. Point to the small square at the lower-right corner of the selection, called the fill handle, and drag it down to B20. You can also double-click the fill handle when there is a continuous neighboring column that tells Excel how far to fill. Excel adjusts the cell reference for each row: the formula in B3 refers to A3, the formula in B4 refers to A4, and so on. Check the final row to confirm the formula covered the entire list.
- Review the converted results. Look down the output column and compare several entries with the originals, including the first and last rows. Confirm that the converted text is in the expected rows and that names, codes, punctuation, and spaces have not been confused with adjacent data. If a result looks wrong, click its cell and inspect the formula bar; it should refer to the source cell on the same row.
- Decide whether to keep the formula or replace the source. If you want a live result that updates when the original changes, leave the formula column in place. If you want the lowercase text to stand on its own, select the results, copy them, then select the destination cells and use Home > Paste > Values. In Windows, the Paste Values command is available from the Paste menu on the Home tab. On Mac, use Home > Paste and choose the Values option in the paste menu. Pasting values prevents the output from depending on the original cells.
- Replace the original only after checking. To make the lowercase text take the place of the uppercase source, copy the completed output range and paste values over the original range. For the example, copy B2:B20, select A2, and choose Home > Paste > Values. Verify that A2:A20 now contains the lowercase entries before deleting the helper column. Avoid cutting and moving the formula column over its own source range: the formulas may change references or stop returning the intended text.
Excel for Mac uses the same LOWER function and essentially the same fill-handle method. In Excel for the web, enter the formula in the browser and fill down as above; the exact appearance of the ribbon can vary, but the formula itself is unchanged. If the workbook is shared or important, keep a separate copy or preserve the original column until the conversion is confirmed.
Common Mistakes
- Expecting Caps Lock to convert selected cells: Caps Lock changes keyboard input, not text already stored in the worksheet. Use LOWER or one of the conversion methods below for existing data.
- Overwriting the source too soon: Putting the formula into the same cell it refers to can produce a circular-reference warning. Use a separate output column, check it, and then paste values over the original only if that is what you want.
- Copying formulas when you meant to keep text: A formula result may look like ordinary text, but it still depends on the referenced cell. Use Paste Values if the source will be deleted or the converted entries need to be fixed in place.
- Filling only part of the range: A short drag can leave some rows unchanged. Compare the output range with the source range and inspect the bottom of the list before copying results.
- Expecting LOWER to clean or rewrite the data: LOWER changes letter case only. It does not remove extra spaces, fix spelling, standardize punctuation, or convert text that is stored as a number into a new format.
Tips
- Keep a backup of important data. Before replacing a large or valuable list, duplicate the worksheet or save a copy of the workbook. This gives you a straightforward way to restore the original if you paste into the wrong range.
- Use Flash Fill for a one-time conversion. In desktop Excel, with uppercase examples in A2:A20, type the lowercase version of A2 into B2. Select B3, then choose Data > Flash Fill. Excel attempts to recognize the pattern and fill the remaining rows. Review every result, because Flash Fill produces values based on a pattern rather than a formula. If the command is unavailable or the results are inconsistent, use LOWER instead. Availability and behavior can vary in Excel for the web, so use the formula method there when needed.
- Keep labels and identifiers in mind. Lowercasing a list of names may be appropriate for your purpose, but product codes, email addresses, or other identifiers may have formatting rules of their own. Check whether the receiving system expects a particular case before replacing the source.
- Use the same approach for selected ranges of different sizes. Enter LOWER beside the first populated row, then fill down only as far as needed. You can repeat the method for another column, but do not include headers unless you want the header text converted too.
- Remember that formula results update. If you edit a source cell later, its LOWER result changes automatically. That is useful when maintaining a list. If you need a final, unchanging copy, paste values after the last edit.
Troubleshooting
The cell shows the formula instead of lowercase text. First check whether the cell is formatted as Text. Select it, choose Home > Number Format, and set it to General. Then re-enter the formula by clicking the formula bar or pressing F2 and pressing Enter. Also check whether Show Formulas is turned on; on Windows, press Ctrl+grave accent to toggle it. If the sheet displays formulas throughout rather than results, this setting is a likely cause. On Mac, use the Formulas tab and turn off Show Formulas if it is enabled.
The result is #NAME? or another error. Confirm the function is spelled LOWER and that the formula starts with an equals sign. For the example layout where A2 contains the source and B2 contains the result, the formula in B2 should be =LOWER(A2). Check that you have not typed extra characters or used a cell address that does not exist. If Excel suggests a function while you type, choose LOWER from the suggestions or finish typing it exactly.
Only the first row changed. The formula may not have been filled down. Select the result cell, then drag its fill handle to the last row of the source list. If the adjacent column contains gaps, double-clicking the fill handle may stop early; dragging to the required last row is more reliable. Check that each formula refers to the matching source row.
Some rows look unchanged. LOWER leaves digits, punctuation, and already-lowercase letters as they are, so values with no uppercase letters may appear the same. Check the source cell itself and verify that the formula refers to the intended column. If text contains unusual characters or is produced by another formula, inspect its displayed value and test a few rows in the helper column before replacing anything.
Paste Values is missing or the original data was replaced accidentally. Open the Home tab and expand the Paste menu; the Values option may be shown as an icon rather than a text label. If the replacement just happened, use Undo immediately (Ctrl+Z on Windows; Command+Z on Mac) before making other edits. If the change can no longer be undone, restore the saved copy or use the remaining helper column if it still contains the original information.
Frequently Asked Questions
Can I change uppercase text to lowercase without a formula?
Yes. In desktop Excel, Flash Fill can infer the pattern if you type a lowercase example beside the original and choose Data > Flash Fill. Check the filled entries carefully. For a repeatable conversion that updates when the source changes, LOWER is the more dependable choice.
Can I convert the text in the same cells?
Not directly with a LOWER formula that refers to those same cells. Use a separate output range first, then copy the results and paste values over the source. This two-stage process avoids a circular reference and gives you a chance to check the output before replacing anything.
Will LOWER change numbers, punctuation, or spaces?
It changes uppercase letters to lowercase. Digits and punctuation stay as they are, and the function does not trim or normalize spaces. If you need to clean extra spaces too, treat that as a separate step and check the results before overwriting the source.
Does this work in Excel for Mac and Excel for the web?
Yes. LOWER works in both, and you can fill the formula down in each version. Ribbon layouts and paste menus can look different, and Flash Fill may not be available in every web experience; the formula method is the consistent option.
Can I make everything lowercase automatically as I type?
Excel does not have a worksheet setting that forces all typed entries to lowercase. You can use a helper formula to display a lowercase version, or use a macro for a specialized workflow. A macro changes workbook behavior and should only be used when appropriate; save a copy before running one because macro actions cannot be undone with Ctrl+Z.
Why did some text remain uppercase after using Flash Fill?
Flash Fill may not have recognized a consistent pattern, especially when the column contains different kinds of content or blank rows. Enter a clearer example and try again, or use a LOWER formula for each row. Formula results are easier to audit because each one points to a specific source cell.
Related
- How to Add a Drop-Down List in Excel
- How ROUNDUP Works in Excel: Syntax and Examples
- How Replace Works in Excel: Find and Replace
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Data Validation INDIRECT Formula: Dependent ListsIn Excel for Microsoft 365 on Windows, use =INDIRECT($A2) as the Data Validation list source in B2 when…
- Excel Filter Not Showing All Data? Find the Cause FastExcel filters usually miss rows because the filter range stops before the full dataset, or because the values…
- Excel Data Validation Custom Formula: Rules and ExamplesIn Excel for Microsoft 365 on Windows, select the cells to control, choose Data > Data Validation, set…
- Excel UNIQUE Sort: List Distinct Values in OrderTo sort unique values in Excel, combine the UNIQUE and SORT functions: if the source values are in…
- Excel SUBSTITUTE Multiple Values: Formulas and TipsTo substitute multiple values in Excel, nest the SUBSTITUTE function for each old-to-new text pair, or use a…
- SUMIF Excel Sum Range: How It Works and ExamplesIn Excel, SUMIF adds values that meet a condition: its range argument is where Excel checks the condition,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.