To change capital letters to lowercase in Excel, use the LOWER function in a blank column: with the text in A2, enter =LOWER(A2) in B2, then fill the formula down. If you need to replace the original entries, copy the results and use Paste Special > Values over the source cells.
Use LOWER to convert text
LOWER is Excel’s built-in function for converting uppercase letters in text to lowercase. It returns a new text result; it does not edit the cell it refers to. That is why the usual method uses a helper column beside the original data.
For example, with the text MAYA CHEN in A2, enter =LOWER(A2) in B2. The result in B2 is maya chen. The function changes the letter case while retaining spaces and punctuation. If the source cell contains a mix of cases, it converts the uppercase letters too: West Wing, ROOM 4 becomes west wing, room 4.
- Select a blank cell on the same row as the first entry, such as B2 when the source is in A2.
- Type
=LOWER(A2)and press Enter. - Check that the result is correct, then copy the formula down the rows you need to convert.
The function is available in Microsoft Excel for Microsoft 365 on Windows and Mac, and in Excel for the web. It is also present in many earlier desktop versions. If Excel displays a formula error, check that the cell reference matches your data and that the formula begins with an equals sign.
Fill the formula down a column
For a short list, drag the fill handle—the small square at the bottom-right corner of the selected formula cell—down to the final row. Excel adjusts the relative reference as it fills: a formula that refers to A2 becomes one that refers to A3 in the next row, then A4, and so on.
For a longer, uninterrupted list, double-click the fill handle. Excel generally fills the formula down to match the neighboring data range. Check the last few rows afterward, especially if there are blank cells in adjacent columns or the source data has gaps; the automatic fill may stop before or behave differently from the range you intended. You can also select the destination range and fill down with Ctrl+D on Windows. On Mac, use Command+D.
When the source range is an Excel table, entering the formula in the first row of a new table column will usually fill the calculated column automatically. This is convenient for data that grows over time, but verify the new column’s results and name. If you are converting a fixed list rather than maintaining a table, ordinary fill-down is straightforward and easy to inspect.
Replace the original entries with lowercase text
A formula cannot safely replace its own source cell: if you put a formula in A2 that refers to A2, Excel creates a circular reference. Instead, convert the values in a separate column, verify them, and then copy the results back as values. This preserves the converted text without leaving formulas that depend on the source range.
- Put the LOWER formula in a helper column and fill it through all the relevant rows.
- Review several results, including entries near the top and bottom of the list.
- Select and copy the converted cells.
- Select the original cells, then choose Home > Paste > Paste Special > Values. Depending on the ribbon layout, you can also right-click the destination and choose the values paste option.
- Confirm that the original cells now contain lowercase text, then remove the helper column if you no longer need it.
Paste values is important: a normal paste would copy the formulas, which may keep pointing at the helper column. If the original data matters, keep a backup copy or duplicate the worksheet before overwriting it. This is particularly sensible when the source is imported, shared, or difficult to recreate.
Convert a large range more safely
For thousands of rows, the same method works; the main difference is how carefully you select the range. Check that the helper formula starts on the same row as the first source value and that you fill only as far as the intended data. If the source column has a header, do not include the header in the formula fill unless you deliberately want to transform it as text.
Before replacing anything, compare a few source and result cells. Look at rows with spaces, punctuation, numbers, or unusual names, not only simple examples. If the worksheet has filters, hidden rows, or multiple noncontiguous selections, take extra care when copying and pasting: the visible subset may not be the same as the full range. For a one-time cleanup, a copied worksheet provides a useful fallback if the range selection is wrong.
Keep the helper column when you want the lowercase result to update if the original text changes. Use Paste Special > Values when you want a fixed result that no longer changes with its source. That distinction matters in recurring reports: formulas are useful for repeatable transformations, while values are often easier to hand off as a finished dataset.
Use Flash Fill for a quick one-time conversion
Flash Fill can recognize a pattern from examples and fill the rest of a column. In the column beside the source, type a lowercase version of the first entry. Type a second example if the pattern is not obvious, select the cells where you want the remaining results, and use Data > Flash Fill. In Excel for Microsoft 365 on Windows, Ctrl+E is the Flash Fill shortcut.
Flash Fill is an alternative to writing a formula, not a formula-based conversion. Its results are fixed text, so they will not recalculate if the source changes. Review the output before relying on it, especially with names, codes, or entries that do not all follow the same pattern. For example, a list containing both personal names and product identifiers may lead to inconsistent guesses. If you cannot find Flash Fill in your version or on your platform, use LOWER instead; the formula method is explicit and easier to audit.
What LOWER changes—and what it leaves alone
LOWER changes letter case, not the underlying meaning or structure of an entry. It does not remove leading or trailing spaces, standardize spelling, split names into separate columns, or correct inconsistent punctuation. If a value includes digits, those digits remain unchanged. For example, ORDER 71-A becomes order 71-a, while the number and hyphen stay as they were.
Applying lowercase to every character can be undesirable for abbreviations, product codes, or text where capitalization carries meaning. It will turn an entry such as an all-caps acronym into lowercase as well. If only selected records should change, filter or select those records carefully and convert just that subset, or use a separate helper column with a conditional approach suited to your data. Do not assume that lowercase is automatically the correct format for every identifier.
Excel stores text and displays it according to the value or formula result. Changing the font, using a cell format, or changing the appearance of the letters does not perform the same conversion. LOWER changes the text returned by the formula, which is why copying and pasting values can make the converted case permanent.
Common problems and how to fix them
- The formula appears as text. Check that the cell is not formatted as Text and that there is no apostrophe before the equals sign. Change the cell format to General, then re-enter the formula.
- The result is unchanged or refers to the wrong row. Confirm that the cell reference points to the source entry. When filling down, relative references should advance one row at a time.
- Only some rows converted. Check for gaps in the neighboring data if you used the double-click fill handle. Select the full intended destination range and fill it explicitly.
- The original data was not replaced. A formula result and its source are separate. Copy the helper results and paste values onto the original cells if you need a permanent replacement.
- Spaces remain in the results. LOWER does not trim spaces. If unwanted spaces are present, address that as a separate cleanup step and inspect the source before overwriting it.
Excel’s Find and Replace is not a lowercase conversion tool. It replaces matching text with other text, but it does not provide a general command to change the case of every letter in selected cells. Likewise, changing the font or typing a new display format will not convert the stored text. Use LOWER, Flash Fill, or a data-transformation workflow for actual case conversion.
Choose between formulas, Flash Fill, and Power Query
Use LOWER when you want a clear, repeatable conversion that can update with the source. Use Flash Fill for a quick, one-time pattern-based result, provided you inspect the output. For a recurring import or repeatable cleanup, Power Query can apply the transformation as part of the data preparation steps.
In Excel for Microsoft 365 on Windows, a typical Power Query workflow is Data > From Table/Range, then, in the Power Query Editor, select the text column and choose Transform > Format > lowercase. Finish with Home > Close & Load to return the results to Excel. The original source data is not directly overwritten by this output; you can refresh the query after updating its source. Menu availability and exact workflow can differ across platforms and versions, so use the formula method if those Power Query commands are not available in your installation.
For a single small list, a helper formula is usually simplest. For a one-off conversion without formulas, Flash Fill may be quicker. For a repeated import process, Power Query avoids having to redo each cleanup manually, but it takes more setup. Choose based on whether the result needs to update, whether you need a fixed copy, and how often the data arrives.
Frequently Asked Questions
Can I change text to lowercase without a formula?
Yes. Flash Fill can infer lowercase output from examples and produce fixed text, and Power Query can transform a column during data preparation. For a small one-time task, Flash Fill is often the quickest alternative; check its results before replacing the source.
How do I make the lowercase result permanent?
Copy the cells containing the LOWER results, select the original range, and choose Home > Paste > Paste Special > Values. This replaces formulas with their current text results. Keep a copy of the original data if you may need to restore it.
Does LOWER change numbers or punctuation?
No. LOWER changes letter case. Numbers, spaces, and punctuation remain as they are, so it will not remove extra spaces or reformat a code.
Can I convert an entire column at once?
Yes. Enter the formula beside the first data row and fill it down to the last row, or use a table’s calculated column. Review the range boundaries before copying results over the source column.
Why can’t I type the formula over the text I want to convert?
The formula needs to refer to the original text, so placing it in that same cell would create a circular reference. Put the formula in another column first, then copy and paste its results as values if you want to replace the source.
Related
- Fill an Excel Column With Weekday Dates Automatically
- Excel File Too Large to Send? Fixes and Workarounds
- Export to CSV vs Excel: Which Format Should You Choose?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Find Duplicate Names in a Name ListTo find duplicate names in Excel, use =COUNTIF($A$2:$A$20,A2)>1 beside a list in A2:A20, then fill the formula down.…
- Excel Payment Tracker: Setup, Formulas, and Practical TipsAn Excel payment tracker is a worksheet for recording what is owed, what has been paid, when payments…
- Excel Greater Than Formula: Compare Numbers and ValuesTo test whether a number is greater than another value in Excel, use the greater-than operator >. For…
- Show Formulas in Excel on iPad: View Cell FormulasIn Excel on iPad, tap a cell to see its formula in the formula bar. To display formulas…
- Excel Length of Service Formula: Calculate Years and MonthsIf the start date is in B2 and the date to measure service through is in C2, use…
- Excel Filter: Begins With Multiple Criteria in Microsoft 365Yes. In Excel for Microsoft 365 on Windows, choose Data > Filter, open the column’s filter menu, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.