Use an uppercase formula
If the original text is in A2, enter =UPPER(A2) in an adjacent empty cell. The formula returns an uppercase version of the text value. Fill the formula down for the rows you want to process.
Work in a spare column first, so the source values remain available while you assess the transformed results.
Keep casing choices distinct
Microsoft documents UPPER for uppercase, LOWER for lowercase and PROPER for initial capitals. PROPER is not a guaranteed spelling correction for people’s names, abbreviations or organization names.
Choose the transformation that the data needs instead of applying the same rule to every column.
Preserve values deliberately
A formula remains linked to its source cell. When a workflow requires fixed results, use Excel’s values-only paste option on a copy of the output, then inspect that copy before replacing the original data.
Keep identifiers and mixed-case product names under review: a readable display treatment and a required stored value can have different needs.
Choose the font separately
Use Excel’s ordinary font controls if the task is appearance rather than capitalization. Read the Excel default-font guide when you want to change the default for new workbooks.
An all-capitals font preview does not prove that the underlying cell value has changed. The formula output is the relevant result for data conversion.
Your questions, answered.
Is UPPER a font?
No. It is an Excel text function that changes capitalization in the returned value.
Can changing a typeface replace the UPPER formula?
A font can draw letters differently without changing the stored text. Use the text function when the value itself needs uppercase characters.
Sources & background
Sources supporting this page’s explanations. Practical examples are our editorial suggestions.