Yes. In Excel for Microsoft 365 on Windows, use the UPPER function to turn lowercase text into uppercase, for example =UPPER(A2) when the text is in cell A2. You can also use Flash Fill or Power Query; the best choice depends on whether you want a live formula, a quick one-time conversion, or a repeatable data-cleaning step.
Why Excel Does Not Have a Case-Change Button
Excel does not provide a simple ribbon button that changes selected cell text from lowercase to uppercase in place. Its text case tools work differently from the Change Case command in Microsoft Word. In Excel, you typically create uppercase text in another column, then decide whether to keep the original or replace it with the converted result.
This distinction matters because a worksheet cell can contain a value, a formula, or a number with a display format. Changing a font or number format will not turn lowercase letters into uppercase. To change the actual text, use a text function or a data transformation feature. The same approach works for a single cell or a large list of names, labels, product codes, and other text.
Use the UPPER Function
UPPER is the most direct and dependable method when you want a formula-driven result. It returns the text supplied to it with lowercase letters converted to uppercase. It leaves characters that have no letter case, such as digits, spaces, and most punctuation, unchanged. It also leaves letters that are already uppercase as they are.
With the text to convert in A2, enter =UPPER(A2) in another cell, such as B2, and press Enter. If A2 contains maria lopez, B2 displays MARIA LOPEZ. If A2 contains order-42a, the result is ORDER-42A. The source in A2 remains unchanged because the formula produces a result in B2 rather than editing its input.
To enter the function in Microsoft 365 for Windows:
- Click the destination cell beside the text you want to convert.
- Type
=UPPER(, select the source cell, type), and press Enter. - Check the result, then fill the formula down if there are more rows.
Excel function names are not case-sensitive, so typing upper or UPPER works. In standard English-language Excel installations, commas separate arguments in formulas that have multiple arguments. This function takes one argument, so its example has no separator to worry about.
Convert a Whole Column
For a list, put the formula beside the first data row and copy it down. If the source values begin in A2, enter =UPPER(A2) in B2. Select B2, then drag the small square at the lower-right corner of the selection down through the rows, or copy B2 and paste into the rest of column B. Excel adjusts the reference for each row: the next formula refers to A3, then A4, and so on.
For a long or regularly growing list, format the source range as an Excel table using Insert > Table. A formula entered in a table column is generally filled through that column, including new table rows. Keep the converted results in a clearly named column, such as Uppercase Name, so it is obvious which cells hold the original values and which hold the transformed output.
Check the top, middle, and bottom of the results before using them elsewhere. This is especially useful if the source column has blank rows, mixed data types, or a heading included in the selected range. The formula will return an empty-looking result for a blank referenced cell, but the formula cell itself is not actually empty.
Replace the Original Text with Uppercase
A formula is a live link to its source cell. If the source changes, the uppercase result updates too. If you want to keep only the converted text, copy the formula results and paste them as values. This removes the formulas while preserving the uppercase output.
- Make the uppercase results in a separate column and review them.
- Select and copy the results.
- Select the original cells if you want to replace them.
- Choose Home > Paste > Values. In many Excel builds, the Values option is also represented by a clipboard icon marked 123.
- After checking the replaced data, remove the temporary formula column if you no longer need it.
Replacing the source this way is usually safer than trying to put a formula into the same cell it reads, which would create a circular reference. Consider saving a copy of the workbook first if the original text is important or the range is large. Once you paste values over the source, the formulas no longer provide a way to recover the old spelling.
Use Flash Fill for a One-Time Conversion
Flash Fill can infer a text pattern from an example you type. It is useful when you want static results quickly and do not need formulas to update later. Suppose A2 contains maria lopez. Type MARIA LOPEZ in B2, then start typing the uppercase version of the next item in B3. Excel may show a suggested fill for the remaining rows. Accept it with Enter, or select the destination cells and choose Data > Flash Fill.
On Windows, Ctrl+E runs Flash Fill when the feature is available and Excel can detect the pattern. The menu command is a useful alternative if the shortcut does not work. On Mac, use Data > Flash Fill where the command is available in your Excel version; keyboard shortcuts can differ by keyboard layout and build. Flash Fill is a pattern recognizer, not a formula, so inspect the results rather than assuming every row was interpreted correctly.
For a straightforward change from lowercase to uppercase, Flash Fill may be more than you need: the UPPER formula is predictable and handles each row consistently. Flash Fill is more attractive when the desired output involves a recognizable pattern alongside the case change, such as rearranging name parts. For just uppercase text, type a few examples only if you specifically want a static result without formulas.
Use Power Query for Repeatable Imports
Power Query is useful when you import or refresh the same kind of data repeatedly, such as a monthly customer list. Instead of changing each sheet by hand, you can apply an uppercase transformation as part of the query. In Excel for Microsoft 365 on Windows, select the source range and use Data > From Table/Range. If prompted, confirm whether the table has headers.
In the Power Query Editor, select the text column, then choose Transform > Format > UPPERCASE. Select Home > Close & Load to return the transformed data to Excel. The query output is separate from the original source, and you can refresh the query when the source data changes. The exact availability and interface of Power Query can vary across Excel platforms and builds, so use the editor offered by your installation.
Power Query is not usually the quickest choice for a single name or a one-off list. It is valuable when the conversion belongs in a repeatable import process, particularly if the data also needs filtering, splitting, or other cleaning. Like a formula result, the loaded output is not the same as editing the original source file; it is query output that can be refreshed.
What Changes and What Stays the Same
UPPER changes letter case, not the underlying meaning or structure of the text. It does not remove extra spaces, correct spelling, standardize punctuation, or decide which words should remain lowercase. For example, turning a person’s name into uppercase changes its presentation, not its spelling. A string such as ab-17 keeps its spaces and hyphen as well as its digits.
Excel stores dates and numbers as values with display formats, so an uppercase text function is intended for text. If a referenced cell contains a number, Excel may convert it to text for the function’s result, but the result is text rather than a numeric value suitable for arithmetic. For identifiers such as postal codes or codes with leading zeros, check how the source was stored and formatted before converting or exporting it.
Uppercase is also different from title case, where selected words begin with capital letters, and from sentence case, where only the start of a sentence is capitalized. Excel’s PROPER function can capitalize the first letter of each word, but that is not a reliable substitute for every name or title because many conventions are irregular. Choose the transformation that matches the data’s purpose.
Common Problems and How to Avoid Them
- The original column did not change: That is expected when using a formula in a neighboring cell. Use Paste Values over the source only after reviewing the output.
- The formula appears as text: The destination cell may be formatted as Text, or the entry may have a leading apostrophe. Change the cell format to General, then re-enter the formula.
- Only one row changed: Copy or fill the formula down the full data range. Check that the row references change as expected.
- Flash Fill misses some entries: It inferred a pattern imperfectly. Use UPPER for uniform case conversion or correct the exceptions manually.
- Numbers or codes look different: Confirm whether Excel treated them as text or numeric values, and verify leading zeros and formatting before exporting.
Also check whether formulas are set to calculate automatically if an output seems stale. In Microsoft 365 for Windows, the calculation setting is available from Formulas > Calculation Options. Most ordinary workbooks use Automatic calculation, but a workbook set to Manual may not recalculate immediately after edits.
Which Method Should You Choose?
Use UPPER when you want a transparent, repeatable formula and want the result to update when the source changes. Use Flash Fill for a quick static result when Excel recognizes the pattern and you are willing to check its output. Use Power Query when uppercase conversion is one step in a recurring import or cleanup workflow. If the final requirement is uppercase text in the original cells, any method that produces a separate result needs a final copy-and-paste-values step.
For most everyday lists, the formula is the best starting point: it is easy to fill down, easy to audit, and does not overwrite the original data. Keep the source and result columns until you have checked the converted text and know whether another person or process depends on the original casing.
Frequently Asked Questions
Can I change lowercase to uppercase in Excel without a formula?
Yes. Use Flash Fill by entering an uppercase example and choosing Data > Flash Fill, or use Power Query for a repeatable transformation. Both create results without a UPPER formula, though you should verify Flash Fill’s pattern.
How do I make the change permanent?
Convert the text in a separate column, copy the results, and use Home > Paste > Values over the original cells. This replaces formulas with fixed uppercase text. Keep a backup if you may need the original casing.
Can Excel automatically uppercase text as I type?
Excel does not have a general worksheet setting that automatically capitalizes every entry as it is typed. A formula column can show uppercase output, and a data-entry workflow or macro can be designed for special cases, but those are different from a built-in case toggle.
Does UPPER change numbers or punctuation?
It changes lowercase letters to uppercase. Digits, spaces, and punctuation do not have letter case, so they remain as they are. If a numeric cell is passed to a text function, check that the result’s text type is suitable for what you plan to do next.
Is there a keyboard shortcut to uppercase selected cells?
There is no general Excel shortcut that directly changes selected text to uppercase in place. Ctrl+E on Windows invokes Flash Fill, which can create uppercase results from a pattern, but it is not an in-place case-toggle command.
Related
- Bullet Point in Excel: Add Bullets to Cells and Lists
- Bullets in Excel: How to Add, Format, and Manage Lists
- Budgeting Template for Excel: Build a Monthly Plan
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Solver Tolerance Settings ExplainedIn Excel Solver for Microsoft 365 on Windows, open Data > Solver, choose Solver Parameters > Options, and…
- Shortcut Key to Refresh a PivotTable in Excel on WindowsIn Excel for Microsoft 365 on Windows, select a cell in the PivotTable and press Alt+F5 to refresh…
- How to Open XML Files in Excel and Import Their DataTo open an XML file in Excel for Microsoft 365 on Windows, use Data > Get Data >…
- Freeze X and Y Panes in Excel: Keep Headers VisibleTo freeze both rows and columns in Excel, select the cell immediately below the rows and to the…
- Excel Shortcut: How to Jump to the End of a ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the lower edge of the…
- Track Changes in Word Anonymously Without Exposing NamesTo track changes in Word without showing your personal name, first set Word’s author information to a neutral…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.