How to Change Caps to Lowercase in Excel Cells

How-to basics · Updated November 20, 2026

To change uppercase text to lowercase in Excel, enter =LOWER(A2) in a blank cell beside the text, replacing A2 with the cell you want to convert, then fill the formula down. To replace the original text, copy the results and paste them back as values.

What LOWER does in Excel

LOWER is a text function that converts uppercase letters in a text value to lowercase. It also leaves letters that are already lowercase unchanged, so it works on mixed-case text without needing a separate rule for each row. For example, a cell containing NORTH WEST becomes north west, while a cell containing North West becomes north west too.

The function changes letter case, not the meaning or other contents of the cell. Spaces, punctuation, numbers, and symbols remain as they are. That makes LOWER useful for standardizing names, email addresses, product codes, imported lists, or other text that should appear consistently in lowercase. It does not remove extra spaces or correct spelling; those are separate cleanup tasks.

LOWER returns a result in a new formula cell. It does not directly edit the text in the cell it refers to. This is why the usual process has two parts: create lowercase results in a helper column, then decide whether to keep the formulas or replace the original entries with fixed values.

Convert a column with a formula

For a list in a worksheet, use a spare column next to the source data. In this example, the text is in A2:A100 and the adjacent cells in column B are available for the results. Enter this formula in B2:

With the original text in A2:A100 and the first result cell in B2, enter =LOWER(A2). If A2 contains NORTH WEST, B2 displays north west.

  1. Click the first empty cell beside the first entry, such as B2.
  2. Type the LOWER formula and press Enter.
  3. Select B2 again. Drag the small square at the lower-right corner of the selected cell down the column, or double-click that square to fill down alongside nearby data.
  4. Check a few results, including mixed-case entries and any rows with punctuation or numbers.

When you fill the formula down, Excel adjusts the reference for each row: the formula beside A3 refers to A3, and the formula beside A4 refers to A4. If the list is an Excel table, entering the formula in the first row of the adjacent table column will often fill the calculated column automatically. If it does not, copy the formula down as you would in a normal range.

Keep the helper column if you want the lowercase output to update whenever the original text changes. If the source cells are formulas, LOWER can convert their displayed text result too. The result remains dependent on the source, so changes to that source can change the lowercase output.

Replace the original text with lowercase values

If you need the lowercase text to stand on its own, copy the formula results and paste them over the source cells as values. This removes the formulas from the destination and leaves the text they currently display. Make a copy of the workbook or source column first if you may need the original capitalization later.

  1. Complete the LOWER formula down the helper column and confirm the output looks right.
  2. Select and copy the converted cells.
  3. Select the first original cell, such as A2.
  4. On the Home tab, open the Paste menu and choose Paste Values. In Microsoft 365 for Windows, the path is Home > Paste > Paste Values. You can also use the Paste Values option in the right-click paste menu.
  5. Confirm that the original cells now contain the lowercase text, then remove the helper column if you no longer need it.

Copying and pasting normally would put the formulas into the original range. Those formulas would then refer to the same cells they occupy, which creates circular references or unwanted results. Paste Values avoids that by transferring the calculated text rather than the formula. If you paste over important data, Excel’s Undo command can usually reverse the action immediately, but saving a backup first is safer for large or valuable lists.

Use Flash Fill for a one-time conversion

Flash Fill can recognize a pattern from an example you type and fill the rest of a neighboring column. For instance, if A2 contains NORTH WEST, type north west in B2. Start typing the lowercase version of the next entry in B3; if Excel recognizes the pattern, it previews suggestions for the remaining rows. Accept the preview to fill the column, or use Data > Flash Fill.

On Windows, Ctrl+E is the Flash Fill shortcut. Because Flash Fill produces values rather than formulas, it can be convenient for a one-time cleanup when you do not need the output to update with its source. Check the filled results carefully: pattern recognition may not infer every exception correctly, especially when rows contain different formats or inconsistent text.

Flash Fill may be unavailable in some Excel versions or situations, and its behavior can depend on having a clear example and adjacent data. If you do not see a preview, use the menu command if available or use LOWER instead. The formula is more dependable for a large, regular list because it applies the same explicit operation to every referenced cell.

Convert text with Power Query

Power Query is useful when lowercase conversion is part of a repeatable import or cleanup process. In Excel for Microsoft 365 on Windows, select a cell in the data and choose Data > From Table/Range. If the range is not already a table, Excel prompts you to create one; confirm whether the first row contains headers. This opens the Power Query Editor.

In the editor, select the column to convert, then choose Transform > Format > lowercase. Review the preview to make sure the correct column is selected, then choose Home > Close & Load to return the transformed data to Excel. The original source is not simply overwritten by this action: Power Query loads a transformed result, usually as a separate table. If the source data changes, refresh the query to apply the steps to the updated data.

Power Query is often more setup than you need for a short list, but it can be worthwhile when you regularly bring in files that need the same treatment. The available commands and editor layout can differ between Excel for Windows, Mac, and the web. If the described menu path is not present in your version, use a worksheet formula or check the Power Query options available in that edition.

What changes, and what stays the same

LOWER changes the text value it returns; it does not apply a visual font effect or change the font, fill, borders, number format, or alignment. Excel does not provide a general worksheet command that instantly changes the letter case of selected cell contents in place. A custom number format is not a substitute: number formats control how numeric values display, not the capitalization of text strings.

Case conversion also does not repair other data issues. If a cell has leading or trailing spaces, LOWER leaves those spaces in the result. If a name has been typed incorrectly, converting it to lowercase will not correct the spelling. For these jobs, use an appropriate cleanup step in addition to the case conversion, and review the final data before replacing the source.

For most ordinary English text, the visible result is straightforward. If your data includes letters from other writing systems or language-specific casing rules, inspect representative examples after conversion. A spreadsheet’s text functions are not a substitute for checking specialized linguistic requirements in a multilingual dataset.

Choose the method that fits the task

  • Use LOWER in a worksheet when you want a clear, repeatable conversion, need to inspect results beside the source, or expect the source values to change.
  • Use Paste Values after LOWER when you want to replace the original entries with fixed lowercase text and no longer need formulas.
  • Use Flash Fill for a quick, one-time pattern-based conversion when Excel recognizes the example correctly and you can verify the results.
  • Use Power Query when the conversion belongs to a recurring import or data-cleaning workflow that you will refresh.

There is no need to choose a more complicated tool just because the list is long. A formula can handle thousands of rows and is easy to audit. The better reason to use Power Query is repeatability across imports; the better reason to use Flash Fill is convenience for a small, one-off job. If you are unsure, keep the source column and compare it with the converted output before making a permanent change.

Common problems and fixes

  • The original cells did not change. That is expected while the formula results are in a helper column. Copy the results and use Paste Values over the source if you want to replace it.
  • The formula appears as text. Check that the destination cell is not formatted as Text, and make sure the entry begins with an equals sign. If needed, change the cell format to General, then re-enter the formula.
  • The result looks uppercase because of formatting. Check the actual displayed text in the formula bar or a separate cell. Font settings do not normally transform the underlying text, and LOWER’s result should contain lowercase letters.
  • Only some rows converted. Make sure the formula was filled down through the full list. A double-click on the fill handle works best when there is adjacent data to guide Excel; otherwise, drag it to the last row or copy and paste the formula across the intended range.
  • Spaces remain around the text. LOWER changes case only. It does not trim spaces. Treat whitespace cleanup as a separate step and verify that removing spaces is appropriate for the data.

Frequently Asked Questions

Can I change uppercase to lowercase without a formula?
Yes. Flash Fill can create lowercase values from an example when Excel recognizes the pattern. For repeatable or more predictable results, a LOWER formula is usually easier to check. Power Query is another option for a recurring import workflow.

How do I change lowercase back to uppercase?
Use Excel’s UPPER text function in a helper column, then copy and paste the results as values if you need to replace the original text. To capitalize the first letter of each word instead, Excel also has PROPER, though that style is not suitable for every name or abbreviation.

Does LOWER change numbers or punctuation?
No. LOWER converts uppercase letters in text to lowercase; punctuation, spaces, and digits remain unchanged. It does not calculate with a number or alter the cell’s number format.

Can I use LOWER in Excel for the web?
Yes. LOWER is a worksheet function and can be entered in Excel for the web just as it can in the desktop application. Enter it in a neighboring cell and fill or copy it down. Some desktop tools, including particular data-cleanup options, may have different availability or menus online.

Can I lowercase cells directly without a helper column?
Not with the LOWER formula alone, because a formula cannot safely replace the source value it is calculating from. Use a helper column and paste values back, or use a conversion method such as Flash Fill or Power Query, then verify the results.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.