To make text all caps in Excel, use the UPPER function: with the text to convert in A2, enter =UPPER(A2) in another cell. The result is an uppercase version of the text; the original cell stays unchanged.
The Excel formula for all caps
UPPER is Excel’s built-in function for converting lowercase letters in text to uppercase. Its syntax is simple: provide the text, or a cell reference containing text, inside the parentheses. It returns the converted text in the cell where you entered the formula.
With the phrase Quarterly sales in A2, enter =UPPER(A2) in B2. The result in B2 is QUARTERLY SALES. You can type text directly into the function too, but a cell reference is usually more useful because the result updates when the source cell changes.
The formula changes letter case, not the underlying meaning of the text. It does not add spaces, remove punctuation, or change the value in A2. For example, existing spaces and punctuation remain as they are; lowercase letters become uppercase.
How UPPER works
Excel evaluates the formula and displays the converted result in the formula cell. That result is derived from the source value, so it updates if the referenced cell is edited. The source and result are separate: a formula in B2 cannot convert the contents of A2 in place.
UPPER works on text that contains letters, including text mixed with digits or punctuation. Digits and punctuation have no uppercase form, so they remain unchanged. With the product code ab-204 in A2, =UPPER(A2) returns AB-204. If A2 contains a number stored as a number rather than as text, UPPER does not turn it into a word; it is a text-conversion function.
Case conversion follows the text and language rules Excel supports. For common English names, labels, and codes, the result is usually straightforward. If your data includes letters from other writing systems or language-specific casing rules, inspect sample results before applying the conversion broadly.
Convert one cell or a list
For a single entry, put the formula beside the source. To convert a column of names or labels, enter the formula in the first result row and fill it down. For example:
- Put the original text in A2.
- Select B2 and enter
=UPPER(A2). - Press Enter and check the result.
- Use the fill handle at the lower-right corner of B2 to copy the formula down alongside the remaining source rows.
With names in A2:A4—Mina Patel, Owen Brooks, and Lee Chen—and the formula entered in B2 then filled down, B2:B4 displays MINA PATEL, OWEN BROOKS, and LEE CHEN. Excel adjusts the relative reference as it fills the formula: the next row refers to A3, then A4. On Windows, Ctrl+D fills a selected range down when the top cell contains the formula; on Mac, Control+D is the equivalent shortcut in Excel. You can also use Home > Fill > Down.
If the data is in an Excel table, enter the formula in the adjacent result column. Excel commonly extends a formula down a table column as a calculated column, and it will apply the formula to new table rows. Check that the source and result columns have clear headings so it is obvious which values are original and which are converted.
Useful variations and examples
A basic UPPER formula is enough for clean text, but small adjustments can help when the source has extra spaces, blanks, or text spread across multiple cells. Each variation still writes its result in a separate cell.
- Remove extra ordinary spaces while converting: With the text north region in A2, enter
=UPPER(TRIM(A2))in B2. The result is NORTH REGION. TRIM removes leading and trailing ordinary spaces and reduces repeated ordinary spaces between words to one. - Leave a result blank when the source is blank: With source entries in A2:A20, enter
=IF(A2="","",UPPER(A2))in B2 and fill it down. If A2 is empty, B2 displays nothing; otherwise it displays the uppercase text. A formula returning an empty string is not the same as a truly empty cell. - Combine two text cells and capitalize the result: With a first name in A2 and a surname in B2, enter
=UPPER(A2&" "&B2)in C2. If A2 is Mina and B2 is Patel, C2 returns MINA PATEL. The ampersands join the two values with a space between them.
TRIM specifically addresses ordinary spaces; it does not remove every invisible character that can appear in imported text. If a value still looks misaligned after trimming, it may contain a nonbreaking space or another nonprinting character. Diagnose a few representative cells before applying a more elaborate cleanup formula, because different unwanted characters require different handling.
Convert a whole range in Microsoft 365
In Excel for Microsoft 365 on Windows, a dynamic array formula can convert a range in one step. With source text in A2:A5 and the output area B2:B5 empty, enter =UPPER(A2:A5) in B2. Excel spills the four uppercase results down from B2. The values in A2:A5 remain unchanged.
This approach is convenient for a changing list: when the source range is adjusted, the array result can update accordingly, provided the cells where results need to appear are available. If Excel reports a spill error, check for existing content or merged cells in the output area. For a range that may grow unpredictably, consider putting the source data in a table and using a formula in a corresponding table column instead.
Dynamic array behavior is available in Microsoft 365 and newer Excel versions that support dynamic arrays. If your edition does not accept a range as the UPPER argument in this way, use the fill-down method: enter the single-cell formula beside the first item, then copy it through the rows you need.
Keep the uppercase results as fixed text
Formulas are useful while the source data is changing, but sometimes you need a final list that no longer depends on the original cells. Copy the converted cells, then use Home > Paste > Values to replace the formulas with their displayed results. After that, the uppercase text remains even if you delete or change the original source column.
Before replacing formulas, make sure the converted values are correct and that you have a copy of the original data if it may be needed later. Pasting values over the formula cells removes the formulas, so those cells will no longer update when the source changes. You can paste the values into a new location instead if you want to retain both the live formulas and a fixed copy.
Do not try to type a formula into the same cell it references. For instance, putting a formula that refers to A2 into A2 creates a circular reference rather than converting the existing contents. Use a separate output column, confirm the results, and only then decide whether to replace the source values.
Formula versus formatting and other case options
Changing the font or cell format does not convert lowercase text into uppercase. Number formatting can change how certain numbers are displayed, but it is not a general text-case tool. UPPER changes the text result itself, which is why the formula method works for names, headings, IDs, and other text entries.
Excel’s related text functions serve different purposes:
UPPERmakes letters uppercase, such as Mina Patel becoming MINA PATEL.LOWERmakes letters lowercase, useful for normalizing text such as email addresses.PROPERcapitalizes the first letter of each word and makes other letters lowercase. It can produce a title-like result, but may not handle every name, acronym, or brand correctly.
For example, PROPER may change an acronym such as NASA into Nasa, so it is not a substitute for UPPER when every letter needs to be capitalized. Conversely, UPPER is not the right choice when you want conventional name capitalization. Choose based on the intended result, then review exceptions such as initials, product names, and organization-specific spelling.
Common problems and checks
If a formula appears as text instead of calculating, first check that the cell is not formatted as Text. Change the cell format to General, then re-enter the formula so Excel evaluates it. Also check that the entry begins with an equals sign and that Show Formulas has not been turned on, which displays formulas in cells instead of their calculated results.
If results do not update, confirm that calculation is set to Automatic under Formulas > Calculation Options. In manual calculation mode, Excel may wait for a recalculation command before refreshing formula results. Also make sure the formula points to the intended source cell and that the formula was filled down far enough to cover the data.
Unexpected spaces or odd-looking results may come from the source rather than UPPER. UPPER preserves spaces and punctuation, and it does not remove hidden characters. Compare the source with the result, inspect imported records, and test a cleanup step on a small sample. Avoid overwriting the only copy of a source list until the output has been checked.
Frequently Asked Questions
What is the formula to make text all caps in Excel?
Use =UPPER(A2) when the text is in A2. Enter it in another cell to display the uppercase result without changing the original cell.
Can I make text uppercase without a formula?
Excel does not provide a general font-format option that converts existing text to uppercase. A formula is the straightforward method; after checking the results, copy them and use Home > Paste > Values if you need fixed text rather than live formulas.
How do I apply UPPER to an entire column?
Enter =UPPER(A2) beside the first source item, then fill the formula down. In a Microsoft 365 version with dynamic arrays, you can also enter a range-based formula in the first output cell, as long as the spill area is clear.
Does UPPER change the original text?
No. It returns a converted result in the cell containing the formula and leaves the referenced source cell intact. To replace the source, copy the results and paste values over the source only after checking them.
How do I make text lowercase or capitalize words instead?
Use LOWER for lowercase text and PROPER for first-letter capitalization of each word. Review PROPER results carefully because acronyms, surnames, and brand names may need special capitalization.
Related
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
- Data Validation Checklist for Excel: What to Check
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel IFS for Blank Cells: Formulas and Common FixesTo make Excel’s IFS function return a result when a cell is blank, test for a blank first:…
- Excel UNIQUE Function for Data AnalysisIn Microsoft Excel for Microsoft 365 on Windows, use the UNIQUE function to create a live list of…
- Excel Formula for Time Clock Hours In and Out by ShiftFor clock-in time in A2 and clock-out time in B2, enter =MOD(B2-A2,1)*24 to return the shift length as…
- Power BI DAX Concatenate: Examples and UsageIn Power BI DAX, join two text values with the ampersand operator (&) or the CONCATENATE function; to…
- INDEX MATCH Examples: Exact, Two-Way, and Flexible LookupsWith product names in A2:A6, prices in B2:B6, and the product to find in E2, use =INDEX($B$2:$B$6,MATCH(E2,$A$2:$A$6,0)). If…
- Excel NOW Function Not Updating? Causes and FixesExcel’s NOW() function does update, but it does not run like a live clock: it returns the current…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.