To correct capitalization in Excel, use =PROPER(A2) to capitalize the first letter of each word, =UPPER(A2) to make all letters uppercase, or =LOWER(A2) to make them lowercase. Enter the appropriate formula in a neighboring cell, fill it down, and—if you need to replace the original text—copy the results and paste them as values.
What Excel’s capitalization functions do
Excel stores text with the capitalization it was given; it does not automatically standardize names, addresses, or other entries. The three built-in functions change the case of text and return the result in a different cell. They leave the source cell untouched, which makes them useful for cleaning a list without losing the original data.
PROPERcapitalizes the first letter of each word and changes the remaining letters in those words to lowercase.UPPERchanges every letter to uppercase.LOWERchanges every letter to lowercase.
These functions affect letters, not the underlying meaning of the text. Numbers and most punctuation remain as they are. For example, a code such as AB-104 stays AB-104 when passed through UPPER, while a lowercase code becomes uppercase.
Correct case with a formula
Suppose a list of names is in column A, starting at A2. Add a heading such as Corrected name in B1, then enter the chosen function in B2. In Microsoft 365 for Windows, press Enter. Select B2 and drag its fill handle down the list, or double-click the fill handle to fill alongside adjacent entries. Excel adjusts the reference for each row.
With the source text mARIA gARCIA in A2, enter this formula in B2:
=PROPER(A2)
The result is Maria Garcia. With the source text West Division in A2, enter this formula in B2 to produce WEST DIVISION:
=UPPER(A2)
With the source text WEST DIVISION in A2, enter this formula in B2 to produce west division:
=LOWER(A2)
Each example assumes the input is in A2 and the formula is entered in B2. For a longer list, keep the same column arrangement and fill the formula down. If the source column contains blanks, the corresponding result cells will generally display blank as well.
Choose the right capitalization style
The right function depends on what the text represents, not just how it looks. For ordinary names and headings, PROPER is a convenient starting point. For identifiers that must be consistently uppercase—such as a region code or product reference—use UPPER. For email addresses or text that should be normalized to lowercase, use LOWER.
Consider the purpose and expected format before applying a change:
- People’s names: Try
PROPER, then review names that have unusual or known styling. - Headings:
PROPERmakes every word start with a capital, but it is not the same as every editorial title-case convention. - Codes: Use
UPPERorLOWERonly if that case is accepted by the system where the codes will be used. - Sentences: None of these functions applies sentence case.
PROPERcapitalizes every word, including short words in a sentence.
Excel’s text case functions work the same way in Microsoft 365 for Windows and Excel for Mac. The formula names and comma-separated argument style shown here are valid in both. The placement of ribbon commands can differ slightly between platforms, so use the menu paths described below as a guide and check the equivalent command in the version you have.
Replace the original text with corrected results
A formula result updates when its source changes. That is helpful when the original list is still being edited, but it may not be what you want in a finished file or an export. To keep the corrected text while removing the formulas, copy the output range and paste its values over the original range or into another destination.
- Check that the formula results look right, then select and copy the results in column B.
- Select the destination cells. To replace the source, select the matching cells in column A.
- On Windows, choose Home > Paste > Paste Values. In versions where Paste Values appears as an icon or submenu, choose the option that pastes values only.
- Confirm that the text remains after you clear or remove the helper column.
Do not paste formula results over the source cells before copying them. If a formula in B2 refers to A2 and you overwrite A2 with that formula’s result, the formula may lose its input or produce an unintended result. Keeping the helper column until after the values are pasted gives you a chance to compare the two versions. Save a copy first if the source data is important or difficult to recreate.
Why PROPER may not fix names perfectly
PROPER follows a general pattern, not a dictionary of people, places, brands, or editorial rules. It changes the remaining letters of each word to lowercase, so it may alter spelling that is intentionally mixed case. For example, it can turn McDONALD into Mcdonald, and a name or brand written with an internal capital may lose that styling.
It can also capitalize short words that some style guides leave lowercase in titles. Names containing apostrophes, hyphens, particles, or multiple conventions deserve a visual check. Even when the result looks plausible, the function cannot know whether a particular person spells a name with a lowercase particle or an unusual internal capital.
For a small list, apply PROPER and manually edit the exceptions in the final values. For a recurring import, keep a separate correction table or another documented process for known exceptions. Avoid treating automatic capitalization as proof that a name is spelled correctly: case correction does not check spelling, identity, or preferred usage.
Use Flash Fill for a one-time pattern
Flash Fill can recognize a transformation from examples and fill the rest of a column, which can be useful when you want a one-time result rather than formulas. For example, type the corrected form of the first name into the adjacent cell, begin the next example, and let Excel detect the pattern. Review the preview before accepting it; a few examples may not make an ambiguous pattern clear.
In Microsoft Excel for Microsoft 365 on Windows, the shortcut is Ctrl+E. You can also use Data > Flash Fill. In Excel for Mac, use Data > Flash Fill if the command is available in your version; the Windows shortcut should not be assumed to work the same way on a Mac. Flash Fill is best for a straightforward, static cleanup. Unlike a formula, its results do not recalculate when the original text changes, and it may infer a pattern incorrectly if the examples vary.
Clean imported text in Power Query
If you repeatedly import or refresh a list, Power Query can apply a consistent case transformation as part of the data-preparation steps. In Excel for Microsoft 365 on Windows, select a cell in the data range and choose Data > From Table/Range. If Excel asks whether the range has headers, choose the appropriate option. In the Power Query Editor, select the text column, then use Transform > Format and choose the available option, such as lowercase, UPPERCASE, or Capitalize Each Word.
Review the preview, then choose Home > Close & Load to return the transformed data to Excel. Power Query keeps the transformation steps, so you can refresh the query when the source data changes. This is useful for repeatable imports, but it still applies general capitalization rules and cannot resolve unusual names automatically. Keep a copy of the original data or retain the source column when later comparison matters. The Power Query interface and available connection options can vary between Excel for Windows, Mac, and the web.
Common problems and checks
If a formula appears as text rather than returning a result, check whether the cell is formatted as Text or whether there is an apostrophe before the equals sign. Change the cell format to General, then re-enter the formula. Also check that the formula begins with an equals sign and that the referenced cell contains the text you intend to change.
- Only one row changed: Fill the formula down the rest of the list; entering it once does not automatically change every existing row.
- The result is wrong for one entry: Check for an exception to the general capitalization rule and correct that result manually after converting it to a value.
- The formula shows an unexpected blank: The referenced source cell may be empty, or the formula may point to the wrong row.
- The original values seem gone: Check whether you pasted over the source. Undo immediately if appropriate, or restore from a saved copy.
Capitalization is also different from case-sensitive comparison. Excel’s ordinary text matching is generally not case-sensitive, so changing a value from apple to APPLE does not necessarily make it a distinct match in a lookup or filter. If the aim is to distinguish text solely by letter case, changing capitalization alone may not solve the underlying problem.
Frequently Asked Questions
How do I capitalize the first letter of each word in Excel?
Use =PROPER(A2) when the source text is in A2. It capitalizes each word and lowercases the other letters; review names and titles because the result may not follow their preferred styling.
How do I make all text uppercase in Excel?
Use =UPPER(A2) in a neighboring cell, then fill the formula down. Copy and paste the results as values if you need fixed text rather than formulas.
Can Excel change text to sentence case?
Excel’s standard PROPER, UPPER, and LOWER functions do not provide sentence case. PROPER capitalizes every word, so it is not a substitute. For a short list, edit the sentence capitalization manually; for a large or recurring task, use a carefully reviewed custom process.
Can I change capitalization without a formula?
Yes. Flash Fill can infer a pattern from examples, and Power Query can apply a saved transformation to imported data. Both approaches need review, especially for names and mixed-case text.
Will changing capitalization affect formulas or lookups?
It changes the text value returned by the cell or stored in the cleaned output. Most Excel text matching is not case-sensitive, so changing case alone usually does not make otherwise identical words distinct in a standard lookup. Check how the receiving system handles case before changing codes or identifiers.
Related
- Choose a Date in Excel: Pickers and Date Lists
- Class Attendance Sheet Template Excel: Setup and Tips
- Choose a Date in Excel: Calendar Options and Steps
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel INDEX MATCH with Multiple Criteria: Real ExampleThe direct answer: use an array formula like =INDEX(C2:C100, MATCH(1, (A2:A100="North")*(B2:B100="Widget"), 0)) entered with Ctrl+Shift+Enter in older Excel,…
- CLEAN in Excel: Formula, Examples, and Common LimitsIn Excel, use =CLEAN(A2) to remove nonprinting ASCII control characters from the text in cell A2. CLEAN can…
- Excel Formula Conditional Formatting by RowTo apply conditional formatting by row in Excel, use a formula that references the row’s first cell with…
- Excel Sequence Month Dates: Formula ExamplesTo create a sequence of monthly dates in Excel for Microsoft 365, enter a starting date in A1,…
- Count Unique Values in an Excel ColumnTo count distinct, nonblank values in an Excel column, use =COUNTA(UNIQUE(FILTER(A2:A100,A2:A100<>""))) in Excel for Microsoft 365 or Excel…
- How to Sort in Excel: Steps, Sort Options, and FixesTo sort data in Excel, select a cell in the list, open Data > Sort, choose the column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.