Yes. In Excel for Microsoft 365, enter =LOWER(A2) in a neighboring cell to convert the text in A2 to lowercase, then fill the formula down; to replace the original entries, copy the results and use Paste Values. Excel also offers Flash Fill and Power Query for other workflows.
What Excel’s lowercase conversion does
The LOWER function changes uppercase letters in text to lowercase. For example, it converts EXCEL TIPS to excel tips and MiXeD Case to mixed case. It leaves lowercase letters, digits, spaces, punctuation, and other characters alone, so a value such as Order #AB-12 becomes order #ab-12.
Excel does not provide a general Home-ribbon button that converts a selected range directly from uppercase to lowercase in place. The usual formula method puts the converted result in another cell, keeping the source intact until you decide what to do with it. That separation is useful: you can compare the result with the original before replacing anything.
LOWER changes the text itself, not just how a cell looks. Changing font, number format, or capitalization-related formatting does not convert the letters. Also, converting text is not always necessary for searching or matching: many standard Excel comparisons and functions, including ordinary equality comparisons and COUNTIF, are not case-sensitive by default.
Use the LOWER formula
Suppose A2 contains the text HELLO Excel. With the source value in A2, enter =LOWER(A2) in B2. The result in B2 is hello excel. The formula refers to the original cell, so you can leave column A untouched while you check the converted values in column B.
- Select the first empty cell beside the text you want to convert, such as B2.
- Type
=LOWER(A2), changing A2 to the address of the first source cell if needed, and press Enter. - Select B2 and fill the formula down. Drag the small fill handle at the lower-right corner of the cell, or double-click it when there is adjacent data to guide the fill.
- Review the converted results for unexpected blanks or values that should not be changed.
For a concrete example, if A2 contains NEW YORK, A3 contains McKay, and A4 contains 2026 Report!, the formulas copied down return new york, mckay, and 2026 report!. LOWER does not preserve special capitalization such as the capital M in McKay; its purpose is to make letters lowercase throughout the text.
For a formatted Excel table, entering the formula in the first row of a new table column will often fill the calculated column automatically. If the formula does not fill, use the fill handle or copy and paste it into the remaining rows. The cell reference adjusts as the formula moves: the formula in B3 will refer to A3.
Replace the original text with lowercase results
A formula result is not the same as changing the source cell. If you want the lowercase values to become permanent entries in the original column, first calculate them in a helper column and inspect them. Then copy the result cells and paste their values over the source range.
- Select and copy the completed formula results.
- Select the first cell of the original range you intend to replace.
- Choose Home > Paste > Values. Depending on the ribbon layout, Values may appear as a clipboard option or in the Paste menu.
- Check several cells, then remove the helper column if you no longer need it.
Paste Values replaces formulas with their current results, so the converted entries no longer depend on the source cells. This is effectively a permanent replacement unless you undo it immediately or restore the data from a backup. Keep a copy of the original column or workbook until you have confirmed the outcome, especially when the data is important.
If you paste formulas instead of values, the destination cells will continue to refer to the original data. If you later delete that source, the formulas may show errors. This is why the Values option matters when the goal is to finish with plain lowercase text in the original location.
Use Flash Fill for a one-time conversion
Flash Fill can infer a text pattern from examples you type. It is useful when you want a quick, static result and do not need a formula that updates as the source changes. For example, with uppercase entries in A2:A10, type the lowercase version of A2 in B2, then begin entering the lowercase version of A3 in B3. If Excel recognizes the pattern, it previews the remaining results; accept the preview to fill them.
You can also select the cells where you want Flash Fill results and choose Data > Flash Fill in Excel for Windows. The Windows shortcut is Ctrl+E. Flash Fill produces values rather than a live LOWER formula, so changing the source later will not automatically revise those results. Always review the filled column: pattern recognition can be wrong when the source contains inconsistent spacing, mixed formats, or text that should be handled differently.
Flash Fill is not a substitute for a repeatable data-cleaning process. If new rows will be added regularly, formulas or Power Query are generally easier to refresh consistently. The Data-tab command is the more dependable route if you are using a keyboard or ribbon arrangement where the shortcut is unavailable.
Convert a column with Power Query
Power Query is a better fit when lowercase conversion is one step in a recurring import or cleanup process. In Excel for Windows, select the data and open it in Power Query using Data > From Table/Range. In the Power Query Editor, select the text column, then choose Transform > Format > lowercase. The preview shows the transformed values before you load the results back into Excel.
Power Query records the conversion as a transformation step. The query output can be refreshed when the underlying source data changes, and the original source is not normally overwritten by loading the query results to a separate worksheet or destination. That makes it more suitable than a one-off Flash Fill operation for repeatable work. Confirm the load destination and retain the source data as appropriate for your process.
Make sure the selected column is treated as text. A date, number, or other typed value is not ordinary text just because it appears in a worksheet cell. Power Query may apply type conversion steps as well as the lowercase step, so inspect the preview and the applied steps if the result differs from what you expect. Power Query is available in Microsoft 365 desktop Excel, though menus and capabilities can differ by platform and build.
Choose the method that fits the job
The right approach depends on whether the conversion is temporary, permanent, or part of a recurring workflow. Consider these practical differences:
- LOWER formula: best when you want a transparent result that updates with the source. It requires a helper column until you choose to paste values.
- Paste Values: best for replacing a range after checking formula results. It makes the converted text static, so preserve the source first if you may need it.
- Flash Fill: convenient for a quick, one-time transformation based on a recognizable pattern. Its results do not update automatically.
- Power Query: useful for repeatable imports and data-cleaning steps that can be refreshed. It has more setup than a simple formula.
If the original entries must remain available for auditing, reporting, or comparison, do not overwrite them. Keep the original column and use the lowercase version in a separate field. If you only need a lowercase display for a report, a formula-driven helper column may be more useful than permanently changing the data.
Limits and common problems
LOWER is designed for text. If a cell contains a numeric value or a date stored as a number, referencing it with LOWER may produce a text representation that does not look like the formatted number or date you see in the worksheet. For example, a date cell may display as a calendar date while its underlying value is a serial number. Avoid running text conversion across mixed data without checking which columns contain text, dates, or numbers.
The function also does not remove leading or trailing spaces, fix spelling, or standardize punctuation. If a source entry is HELLO followed by an extra space, the lowercase result still has that space. A separate cleanup step may be needed; do not assume that changing letter case also cleans the entire value.
If Excel displays the formula itself rather than a result, the cell may be formatted as Text or the formula may have been entered with a leading apostrophe. Change the cell format to General, then edit and re-enter the formula. If a formula appears unchanged after editing its source, check whether calculation is set to automatic under Formulas > Calculation Options. In Microsoft 365, LOWER is available without installing an add-in, and the same formula works in Excel for Mac and Excel for the web.
One common misconception is that lowercase conversion changes whether Excel considers two strings equal. Standard worksheet comparisons are generally case-insensitive, so converting both values may not fix a mismatch caused by extra spaces or different punctuation. If case-sensitive comparison is specifically required, that is a separate task; LOWER simply normalizes letter case.
Frequently Asked Questions
Can I change text to lowercase without a formula?
Yes. Flash Fill can create a one-time result from examples, and Power Query can apply a lowercase transformation to a column. For a quick formula-free conversion, Flash Fill is often the simplest option, but inspect the results because it infers a pattern.
Can LOWER change the original cell directly?
Not by itself. The formula returns a result in the cell where you enter it. To replace the source, calculate the results elsewhere, copy them, and use Home > Paste > Values over the original range.
Does LOWER work in Excel for Mac or Excel for the web?
Yes. LOWER is a standard Excel function and the formula syntax is the same. Ribbon locations and the availability of tools such as Flash Fill can vary, so use the formula method if you cannot find the relevant command.
How do I convert an entire column to lowercase?
Enter =LOWER(A2) in a helper column beside the first text entry, then fill the formula down alongside the data. Review the results and, if you need to replace the original column, copy the results and paste values over it.
Will lowercase conversion preserve names such as McDonald?
No. LOWER makes every uppercase letter lowercase, so McDonald becomes mcdonald. If names need conventional capitalization, retain the original data or use a method that lets you review and correct exceptions rather than applying LOWER indiscriminately.
Related
- Excel Not Responding? How to Save Your Work
- Excel Not Responding? Recover an Unsaved File
- Excel Nested Group Rows: How to Create and Use Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Date Difference: Formulas and ExamplesTo calculate the number of days between two dates in Google Sheets, subtract the earlier date from the…
- Excel Merge Cell Shortcut: Keys and Safe AlternativesIn Excel for Microsoft 365 on Windows, press Alt, H, M, C in sequence to merge the selected…
- Outlook Image Cache: How to Clear It on Any DeviceTo clear stale images in Outlook, use the method for the version you have: in classic Outlook for…
- Autofill Weekday Dates in Excel and Skip the WeekendsTo autofill weekdays in Excel and skip Saturdays and Sundays, enter a starting date in A2, then put…
- How to Check Double Spacing in WordTo check whether text is double-spaced in Word, place the cursor in a paragraph or select the paragraphs,…
- Microsoft Word: Add a Header to the First Page OnlyTo add a header to only the first page in Microsoft Word, open the header, select the Header…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.