Yes. In Excel for Microsoft 365 on Windows, use PROPER to capitalize the first letter of each word, UPPER to make text all capitals, or LOWER to make it all lowercase. These formulas create changed text in another cell; Excel does not have a built-in ribbon button that changes the case of selected cell contents in place.
What capitalization options does Excel offer?
Excel’s three familiar text functions cover most basic case changes. The right choice depends on what the text represents, because title-style capitalization is not always appropriate for an email address, code, or official name.
PROPERchanges the first letter of each word to uppercase and the remaining letters to lowercase. For example, it turns mARY jONES into Mary Jones.UPPERchanges all letters to uppercase, such as turning west region into WEST REGION.LOWERchanges all letters to lowercase, such as turning Sales.Team@example.com into sales.team@example.com.
All three functions return text. They do not change the original cell’s number format, font, or visual styling; instead, they return a text result that you can keep in a helper column or copy back over the original data as values.
How to capitalize each word with PROPER
Suppose a list of names is in column A, with the first name in A2. Click B2, enter the formula below, and press Enter. If the name in A2 is mARY jONES, the result in B2 is Mary Jones.
With the source text in A2, use =PROPER(A2).
To apply the formula to additional rows, select B2 and drag the fill handle—the small square at the lower-right corner of the cell—down the column. You can also double-click the fill handle when there is adjacent data to guide the fill. Excel adjusts the reference for each row, so the formula in B3 refers to A3. Check the results before replacing source data, especially when the entries contain initials, compound names, or abbreviations.
If the source is an Excel table, enter the formula in the first row of a new table column. Excel generally fills the calculated column down for the rest of the table and applies it to new rows. A helper column is useful because it leaves the original values available for review.
Make text all uppercase or lowercase
Use UPPER when a consistent all-caps result is required, for instance for a short department label or an identifier that is conventionally uppercase. With the source text in A2, use =UPPER(A2). If A2 contains west region, the result is WEST REGION.
Use LOWER when all letters should be lowercase. With the source text in A2, use =LOWER(A2). If A2 contains Sales.Team@example.com, the result is sales.team@example.com. Lowercase email addresses can be helpful for consistent display or comparison, though an organization’s systems may have their own rules for handling addresses.
These formulas affect letters, not the meaning or validity of the text. For example, converting a product code to lowercase may make it unsuitable if another system treats uppercase and lowercase codes differently. Choose a standard that suits the data’s purpose rather than applying one case to every column.
What PROPER does—and what it does not know
PROPER follows a mechanical rule: it capitalizes the first letter after a character that is not a letter and converts other letters in a word to lowercase. It does not consult a dictionary or recognize names, brands, languages, or editorial style. That makes its results predictable, but not always correct.
For example, it may turn a name such as McDONALD into Mcdonald, or change an acronym such as NASA into Nasa. It may also capitalize after punctuation or spaces in ways that do not match a person’s preferred spelling. Names with apostrophes and hyphens can need particular attention; the function’s rule is based on characters, not knowledge of how each name is conventionally written.
For a small list, the practical approach is to use PROPER for a first pass and then review exceptions against a trusted source. For a large, recurring list, keep a correction table or use a controlled data-cleaning process instead of assuming one formula can infer every preferred spelling. If the desired output is a heading style rather than a name-normalization rule, decide first whether words such as and, of, or the should remain lowercase; PROPER will capitalize them too.
Keep the result or replace the original values
Formulas update when their referenced cells change. That is useful when the source list is still being edited, but a formula result is not a fixed replacement for the source. If you want to keep the converted text without formulas, copy the results and paste them as values.
- Fill the formula down the helper column and review the converted entries.
- Select and copy the helper-column results.
- Select the destination cells, then use Home > Paste > Paste Values. In Excel for Microsoft 365 on Windows, you can also right-click the destination and choose the values paste option.
- Confirm that the pasted text is correct before deleting the original column. Keeping a backup until you have checked the results makes errors easier to recover from.
When replacing the original column, copying the results and pasting values over the source cells breaks the formulas’ dependency on that source. Do not simply delete the source column while formulas still refer to it; the results may change or show errors. In Excel for the web, the same general formula and copy-and-paste-values workflow is available, though the exact paste controls can look different. On Mac, use the Home tab’s paste options or the contextual paste menu; keyboard shortcuts for copying and pasting use Command rather than Ctrl.
Use Flash Fill for a one-time conversion
Flash Fill can infer a text pattern from examples and fill the rest of a column without leaving a formula in each cell. It can be handy for a one-time cleanup when the intended output is clear. For example, if column A contains names and you type the correctly capitalized version of the first name in B2, begin entering the next example in B3. Excel may recognize the pattern and preview the remaining results.
To request it directly in Excel for Microsoft 365 on Windows, select the destination cells and choose Data > Flash Fill, or press Ctrl+E. Inspect the completed column: Flash Fill is pattern-based, and a pattern that fits the first few rows may not handle exceptions elsewhere in the data. It also does not create a live formula, so later changes to the source are not automatically reflected.
On Excel for Mac, Flash Fill is available from the Data tab in supported versions. The keyboard shortcut can differ with the Mac version and keyboard settings, so use the ribbon command if the Windows shortcut does not work. Excel for the web does not offer the same full Flash Fill workflow as the desktop app; use a formula there instead.
For repeated imports, consider Power Query
If you regularly receive a new file that needs the same case cleanup, Power Query can make the process repeatable. In Excel for Microsoft 365 on Windows, select the source data and choose Data > From Table/Range to open the Power Query Editor. Select the text column, then use Transform > Format and choose lowercase, UPPERCASE, or Capitalize Each Word. The precise capitalization label is descriptive: Capitalize Each Word follows a rule like title casing and does not know whether an acronym should stay uppercase.
When the transformation is ready, choose Home > Close & Load to return the cleaned data to Excel. For a later file with the same structure, replace or update the source and refresh the query. This is often more maintainable than manually repeating edits, but it creates a transformed output table rather than changing the source file itself. Menu availability and presentation can vary in Excel for Mac and Excel for the web; use the desktop Power Query Editor when the relevant transformation commands are not shown in your version.
Which method should you choose?
For a few cells or a list that changes over time, formulas are usually the clearest option. They show exactly how each result was produced and recalculate when the source changes. Use Flash Fill for a quick, one-off cleanup when you can inspect its output. Use Power Query when the same transformation is part of a recurring import or data-preparation routine.
- Choose
PROPERfor a general first-letter-of-each-word result, with manual review for names and abbreviations. - Choose
UPPERorLOWERwhen every letter must follow one consistent case. - Choose Flash Fill when you need a fast, static result and can verify the suggested pattern.
- Choose Power Query when you want a repeatable transformation as part of an import workflow.
There is no universal best choice: consider whether the data will change, whether the result must remain linked to the source, how many rows need processing, and how costly an incorrect spelling would be. For important records, preserve the original data until the transformed values have been checked.
Common problems and misconceptions
A frequent misconception is that changing a cell’s font or applying a format will convert its letters to uppercase or title case. Font settings affect appearance, not the underlying text. Excel’s standard number formats also do not provide a general case-conversion setting. Use a text function, Flash Fill, or Power Query to create changed text.
If a formula appears as text instead of calculating, check whether the cell is formatted as Text or whether an apostrophe was entered 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 calculation has not been interrupted by an accidental edit.
If the result looks wrong, inspect the original characters and the function’s rule. Extra spaces can make a list look inconsistent even when capitalization is correct; case functions do not serve as a complete cleanup tool for spacing, spelling, or punctuation. Excel’s TRIM function can remove many ordinary extra spaces, but it does not correct every possible nonbreaking space copied from a webpage. Keep a copy of source data if cleanup steps could discard meaningful distinctions.
Finally, remember that visual case changes can affect how other systems interpret identifiers. Excel text comparisons are generally not case-sensitive, but exported files, databases, programming languages, or external platforms may have different rules. Confirm the receiving system’s requirements before converting codes or keys in bulk.
Frequently Asked Questions
Can I change capitalization in Excel without a formula?
Yes. Flash Fill can make a static result from examples, and Power Query can apply a repeatable transformation. For a small, reliable formula-based conversion, use PROPER, UPPER, or LOWER in a helper column.
Can Excel capitalize only the first letter of a sentence?PROPER capitalizes the first letter of each word, not just the first letter of a sentence. Excel does not have a standard worksheet function that reliably detects sentence boundaries and applies normal sentence case. For a short passage, edit it manually; for larger text, use a purpose-built text-processing method and review its output.
How do I keep the capitalized text but remove the formula?
Copy the formula results, then use Home > Paste > Paste Values in the destination cells. The pasted text remains, while the formulas are replaced by their current results.
Does PROPER preserve acronyms such as NASA?
No. It applies a capitalization rule and may turn NASA into Nasa. Check acronyms, brand names, and personal spellings after using it, and correct exceptions manually or with a controlled lookup process.
Can I capitalize text in place in Excel?
There is no standard Change Case button that directly rewrites selected cell contents in place. Use a helper column, verify the output, and then paste values over the original cells if that is what you need.
Related
- Beyond Compare for Excel: Compare Workbooks and Sheets
- Bill Format in Excel: How to Create and Use a Bill
- Best Excel Templates for a Personal Budget: How to Choose
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Cell Merge Shortcut Keys and How to Use ThemIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, then C to use…
- Excel Data Validation List: How to Add a Blank OptionYes. To add a selectable blank to an Excel data-validation drop-down, include a genuinely empty cell inside the…
- How to Get Rid of Track Changes Lines in Microsoft WordTo hide the vertical lines that mark tracked edits, open the Review tab and choose Display for Review…
- Google Sheets IF Statement With Text: Examples and TipsYes. In Google Sheets, an IF statement can test text and return text: use =IF(A2="Paid","Complete","Pending") to show Complete…
- Excel: Find Names in Two WorksheetsTo find names from one worksheet in another, enter a check formula beside the list you want to…
- How to Clear Search Cache in OutlookTo clear Outlook’s saved search terms in classic Outlook for Windows, click the search box, open the Search…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.