Lowercase Names in Excel: Formula, Fill Down, and Replace

To lowercase names in Excel, use the LOWER function in a helper column, then fill the formula down. If the names are in A2:A100, enter =LOWER(A2) in B2 and copy it down the column. The results are lowercase text; you can keep them beside the originals or paste them over the original cells as values. Make a copy of important data before replacing anything.

What You’ll Need

An Excel workbook with the names you want to change, ideally arranged in one column with a header such as Name.
An empty column for the formula results. Keeping the source names untouched until you check the output makes the process easy to reverse.
Microsoft Excel for Microsoft 365 on Windows for the steps below. The LOWER function also works in Excel for Mac and Excel for the web; the ribbon labels may be arranged differently, but the same formula and copy/paste-values method apply.

Step-by-Step

Check the source column and choose a destination. Find the first name cell and note the range to convert. In this example, the header is in A1 and names are in A2:A100. Confirm that the destination column, B, is empty for the same rows. If it contains important information, choose another empty column or insert one: right-click its column letter and select Insert. Avoid putting the formula in the source cell because it would overwrite the name it needs to read.
Enter the LOWER formula beside the first name. With names in A2:A100 and the first name in A2, select B2 and type =LOWER(A2), then press Enter. Excel displays the text from A2 with its letters converted to lowercase. For example, if A2 contains Maria Chen, B2 displays maria chen. The formula changes letter case; it does not remove spaces, change the order of first and last names, or correct spelling.
Check the first result before copying it. Compare B2 with A2. Confirm that the right source cell is referenced and that the result contains the expected name. If you see a blank, check whether A2 is blank. If you see a formula error, check for a missing equals sign or mismatched parentheses. You can select B2 and read the formula in the formula bar to verify it refers to A2 rather than another row or column.
Fill the formula down through the list. Select B2, point to the small square at the lower-right corner of the cell, and drag the fill handle to B100. Excel adjusts the reference for each row, so B3 uses A3, B4 uses A4, and so on. If the adjacent source column has an uninterrupted list, double-clicking the fill handle can fill down to its last neighboring row. Check the final row afterward; double-click fill can stop early when nearby cells are blank. You can also copy B2, select B3:B100, and paste.
Review the converted names. Scan the top, middle, and bottom of the results for missing entries, unexpected blanks, or a misaligned range. If some original cells are blank, LOWER returns a blank result for those rows. If the source contains a number or a formula that returns text, the output may still look correct, but check that you selected only the intended records. Keep both columns visible until you are satisfied.
Decide whether to keep the original names. If you need both versions, leave the helper column in place and give it a clear header such as Lowercase Name. If you only need the lowercase version, copy the completed results in B2:B100. Select A2:A100, then choose Home > Paste > Values. This replaces the names with plain lowercase text instead of formulas. Do not use a normal paste for this step if you want to remove the formulas.
Remove the helper column only after checking the replacement. Confirm that A2:A100 now contains the lowercase names and that the cells are values, not formulas. Then delete the helper column if you no longer need it: right-click the B column letter and choose Delete. If you decide to keep the original names, do not delete the source column. Save the workbook when the data is in the form you need.
Use the same process for another range if necessary. For names in a different column, change the reference in the first formula to match the first source cell. For instance, if names start in D5, put the formula in an empty cell on row 5 and reference D5. Fill it only to the last row in that list. This keeps the formula aligned with each record instead of applying one row’s name repeatedly.

Common Mistakes

Typing over the source cell. A formula such as =LOWER(A2) needs A2 to remain available as its input. Enter it in another cell, then paste the results over the source only after copying them.
Copying formulas but expecting fixed text. A filled formula continues to refer to the source cells. If you later change or delete the originals, the outputs may change or become blank. Use Paste Values when you want to keep a permanent lowercase result.
Selecting the wrong row range. If the formula starts on row 2 but you paste it starting on row 1 or row 3, names can be offset from other information. Keep the formula and destination range on the same rows as their source names.
Expecting LOWER to clean the data. LOWER changes letter case only. It does not remove leading or trailing spaces, standardize punctuation, or turn a name into title case. Check for those issues separately rather than assuming the case conversion fixed them.
Replacing a column without a backup. Pasting values over the source is a destructive edit, and changes may be hard to restore after saving or closing. Keep the original column until you verify the results, and save a separate copy first if the workbook is important.

Tips

Use a descriptive header. A header such as Lowercase Name makes it clear that the helper column is an output. This is especially useful when a workbook has several name fields, such as billing contact and shipping contact.
Preserve the original when you may need to compare. Keeping both columns lets you review which names changed and gives you a source for correcting mistakes. You can hide the original column later if it makes the sheet harder to read, rather than deleting it.
Use Paste Values when sharing a finished list. A recipient may not need the working formulas or the original data. Pasting values makes the lowercase names independent of the helper formulas and avoids broken references if columns are moved or deleted.
Remember that lowercase may not be the preferred display style. LOWER will convert names such as O’NEILL or McDONALD to o’neill or mcdonald. It does not know which capitalization a person prefers. For customer, employee, or official records, confirm the requested format before replacing the original.
Work on a table carefully. If the names are in an Excel table, add a new table column and enter the formula in its first data row. Excel may automatically fill the calculated column. Check that the formula has populated all table rows before using the results.

Troubleshooting

The formula appears as text instead of returning a name. Check that the cell is not formatted as Text. Change the cell format to General from Home > Number Format, then select the cell, press F2, and press Enter to make Excel evaluate the formula. Also check that there is no apostrophe before the equals sign. If Show Formulas is turned on, formulas may be displayed in cells; use Formulas > Show Formulas to turn that view off.

Only some rows changed. The formula may not have been filled to the end of the list. Select the first result cell and drag its fill handle through the last name row, or copy the formula cell and paste it into the remaining destination range. Check the last few rows and make sure the source references advance row by row.

The result is blank or the wrong name. Click the result cell and inspect its reference in the formula bar. A blank result usually means the referenced source cell is empty. A wrong name often means the formula points to the wrong column, or that the fill began on a different row from the source list. Correct the first formula, then refill the range.

Paste Values is unavailable or the formulas remain. First copy the formula results, then select the destination cells and open the Paste menu on the Home tab. Choose Values, not the regular Paste option. In Excel for Mac or Excel for the web, use the Paste dropdown or context menu and choose the values-only option if shown; menu placement can vary by version. If necessary, keep the helper column and use it as the finished output instead.

The names look lowercase but still contain unwanted spaces. LOWER does not trim spaces. If spaces are causing a separate problem, do not silently replace names based only on appearance: inspect the source and decide whether the extra characters should be removed. Keep the untouched source until that cleanup has been checked.

Frequently Asked Questions

Can I lowercase names in Excel without a formula?
Excel does not have a built-in Change Case button for worksheet cells like a word processor. A formula with LOWER is the straightforward option. Once calculated, use Paste Values if you want fixed text rather than formulas.

Does LOWER change every letter in a name?
It converts uppercase letters to lowercase wherever they appear in the referenced text. Spaces, digits, and punctuation remain as they are. Thus, a name such as ANA-MARIA O’NEILL becomes ana-maria o’neill.

Can I lowercase the names in the same column?
Not by entering a formula directly into each source cell, because the formula would refer to itself or overwrite the input. Use a helper column, copy its results, and paste values over the source range after checking them.

Will the formula update if I change a source name?
Yes. While the result cell contains a formula, Excel recalculates it when the referenced name changes. After you paste the result as a value, it no longer updates automatically.

Can I use this in Excel for Mac or Excel for the web?
Yes. LOWER works in both, and the formula syntax is the same. The ribbon or context-menu location for Paste Values can differ slightly by version, so look for the values-only paste option before replacing the source cells.

Does LOWER capitalize names correctly afterward?
No. LOWER makes all letters lowercase; it does not apply name-specific capitalization rules. Names can have preferred forms that a general capitalization rule cannot infer, so use lowercase only when that is the format you need.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.