Change Block Capitals to Lowercase in Excel

How-to basics · Updated November 19, 2026

To change block capitals to lowercase in Excel, enter =LOWER(A2) in a blank cell beside the text, replacing A2 with the cell you want to convert. Fill the formula down to convert the rest of the list; if you need to replace the original text, copy the results and paste them as values.

How the LOWER function works

Excel’s LOWER function returns text with its uppercase letters converted to lowercase. It does not alter the source cell: the function’s result appears in the cell containing the formula, leaving the original available for comparison or recovery. That makes a formula a safe first choice when the source data matters or may change later.

For example, if A2 contains the text CUSTOMER SUPPORT, and the formula is entered in B2, the result in B2 is customer support. The function also converts mixed-case text, such as Excel Help, to excel help. Numbers, punctuation, spaces, and other characters are not converted into letters, so an entry such as ORDER-42 remains order-42: only its alphabetic characters change case.

With the text to convert in A2, enter this in B2:

=LOWER(A2)

Press Enter to calculate the result. The formula works in Microsoft 365 for Windows and also in current desktop and web versions of Excel. It is useful for cleaning names, email addresses, labels, imported lists, and other text that should follow a consistent lowercase style.

Convert a whole column step by step

For a list, put the formula beside the first item and fill it down. In this example, the original entries are in column A, starting at A2, and the converted results will go in column B.

  1. Insert or select an empty column next to the source data. Add a heading such as Lowercase in B1 if you want to label the results.
  2. With the source text in A2, type =LOWER(A2) in B2 and press Enter.
  3. Select B2 again and point to the small square at the lower-right corner of its selection, called the fill handle.
  4. Drag the fill handle down alongside the source entries. If the neighboring column has a continuous list, you can often double-click the fill handle to fill down to the end of that list.
  5. Check a few results, including any entries with numbers, punctuation, spaces, or unusual characters.

When you fill the formula down, Excel adjusts the cell reference for each row: the next row refers to A3, then A4, and so on. If the source is an Excel table, entering the formula in the first data row of the adjacent table column will usually fill the calculated column automatically. Keep the source and result columns clearly labeled so that someone opening the workbook can tell which values are original.

Replace the original text with lowercase values

A formula is dynamic: if the source changes, its result updates. If you want a permanent conversion and no longer need the original capitalization, convert the formula results into ordinary text values before removing the source.

  1. Select the cells containing the LOWER results and copy them.
  2. Select the destination cells, which may be the same result range or the original source range.
  3. Choose Home > Paste > Paste Values. The pasted cells contain the lowercase text rather than formulas.
  4. Confirm the results before deleting any source column you still need.

On Windows, Ctrl+C copies the selected cells. You can then use the Paste Values command on the Home tab. Ctrl+Alt+V opens Paste Special in many desktop versions of Excel; the available keyboard choices can vary, so use the ribbon command if the shortcut does not behave as expected. On Mac, use the Home tab’s paste options or the Paste Special dialog; keyboard shortcuts differ by keyboard and Excel version. Excel for the web also offers paste options after copying, though the precise menu presentation can differ.

Do not simply type over the source cells with formulas that refer to those same cells: that creates a circular reference or replaces the source before the formula can use it. Put the formula in a separate column first, then paste values into the original range only after checking the results.

Does Excel have a Change Case button?

Excel does not provide the same one-click Change Case button found in Microsoft Word. Typing a selection and looking for a case-changing command on the Home ribbon will not convert the cell contents. In Excel, use a text function such as LOWER for lowercase, UPPER for uppercase, or PROPER for title-style capitalization.

Those functions return results in cells; they are not formatting controls. Changing a font, applying bold, or changing the cell’s number format will not turn uppercase letters into lowercase. The letters themselves must be converted. This distinction matters when you copy data into another program or export a CSV file: a font or display change is not the same as changing the stored text.

Use Flash Fill for a quick one-time conversion

Flash Fill can recognize a pattern from an example and fill neighboring cells without leaving a formula in each result. Put the original text in one column, type the desired lowercase version beside the first entry, and ask Excel to continue the pattern. For instance, if A2 contains a person’s name in capitals, type the same name in lowercase in B2. Select the next result cell or the range to fill, then choose Data > Flash Fill.

In Excel for Microsoft 365 on Windows, Ctrl+E is the Flash Fill shortcut. On Mac, use Data > Flash Fill where the command is available; the Windows shortcut may not apply. Flash Fill is convenient for a quick, fixed result, but it is pattern-based rather than a live formula. Review the proposed output, especially if the source column contains inconsistent spacing, blank rows, mixed formats, or names that do not follow the example. For a large or regularly updated list, LOWER is usually easier to audit and refresh.

Convert text with Power Query

Power Query is useful when lowercase conversion is one step in a repeatable data-import or cleaning process. In desktop Excel for Microsoft 365 on Windows, select a cell in the source table and choose Data > From Table/Range. In the Power Query Editor, select the text column, then choose Transform > Format > lowercase. Choose Home > Close & Load to return the transformed data to Excel.

The query records the transformation, so you can refresh it when the source data changes instead of repeating the cleanup manually. Power Query generally loads transformed output separately from the source; it is not a command that silently edits the original cells. Menu placement and availability can differ between Excel platforms and versions. If you only need to convert a few cells, a formula is usually quicker; if the same cleanup is part of a recurring import, a query can make the process more consistent.

Common problems and how to avoid them

  • The formula appears as text. Check that the cell is not formatted as Text and that the entry begins with an equals sign. Change the cell format to General if needed, then re-enter the formula.
  • The formula is visible instead of its result. Show Formulas may be enabled. Toggle it from the Formulas tab or press Ctrl+` on Windows; the key is usually the grave accent. Mac keyboard layouts can differ, so the ribbon command is the safer alternative.
  • Only one row changed. A formula in B2 converts only the value referenced in A2. Fill or copy the formula down for the remaining rows.
  • The source seems unchanged. That is expected: LOWER writes its result in the formula cell. Use Paste Values if you need to replace the source.
  • Spaces or punctuation remain. LOWER changes letter case, not spacing or punctuation. If an address has unwanted leading or trailing spaces, clean those separately rather than expecting case conversion to fix them.
  • A downstream system treats the result differently. Some systems compare text without regard to case, while others treat uppercase and lowercase identifiers as distinct. Check the receiving system’s requirements before replacing codes, usernames, or keys.

Choosing the right conversion method

Choose the method according to whether you need a live result, a one-time cleanup, or a repeatable import step:

  • Use LOWER when you want a transparent formula, need to preserve the source, or expect the source values to change.
  • Use Paste Values after using LOWER when the final cells should contain fixed lowercase text rather than formulas.
  • Use Flash Fill for a small, straightforward, one-time transformation that Excel can infer from an example.
  • Use Power Query when lowercase conversion belongs in a recurring data-cleaning workflow.

Before converting a column in place, consider why the text is capitalized. A spreadsheet may use capitals to distinguish product codes, acronyms, or manually reviewed entries. Lowercasing email addresses is often a useful consistency step, but other identifiers may have rules set by the service or database that receives them. Keep a copy of the source data until you have confirmed the converted values work in their destination.

Frequently Asked Questions

Can I change uppercase text to lowercase without a formula?
Yes. You can use Flash Fill by entering a lowercase example and choosing Data > Flash Fill, or apply lowercase formatting in Power Query. For a small range, the formula method is usually the clearest and easiest to verify.

How do I convert lowercase text back to capitals?
Use Excel’s UPPER function in a neighboring cell, then fill it down. It follows the same approach as LOWER but converts letters to uppercase. Copy and paste the results as values if you need to replace the source.

Can I change the case in the same cells?
Not directly with a normal formula, because a formula cannot both read a cell’s original value and replace that value in place. Create results in another column, check them, then copy and use Paste Values on the original range if replacing it is appropriate.

Will LOWER change numbers or punctuation?
No. LOWER converts uppercase letters to lowercase; digits, hyphens, commas, and other nonletter characters remain as they are. It also does not remove extra spaces or correct spelling.

Does the LOWER formula work in Excel for Mac and Excel for the web?
Yes. LOWER is a standard Excel function and works in current Excel desktop and web versions. Ribbon locations and keyboard shortcuts for actions such as Flash Fill or Paste Special may differ, but the formula itself is the same.

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.