Arrow left
Back to guides
Excel Formulas

UPPER Function in Excel: Explained

In this article, you will learn how to use the UPPER formula in Excel.


What does the UPPER formula do in Excel?

The UPPER function in Excel is used to capitalize all letters of an input string. The function converts an input text string to all uppercase letters.


When is the UPPER function helpful in Excel?

The UPPER formula can be a useful tool for formatting, cleaning, and standardizing text in Excel. Some common uses can be as below:

  1. Formatting: You can use the UPPER formula to format text so that it is in all uppercase letters. This can be useful for headings, titles, or other text that needs to stand out.
  2. Data cleaning: If you have imported data from another source, it is possible that some of the text may be in lowercase or mixed case. You can use the UPPER function to standardize the text and make it consistent.
  3. Data entry: By using the UPPER formula, you can ensure that the text entered into a cell is always in uppercase, regardless of how it was entered


How to use the UPPER function in Excel

  1. Select the cell where you want to display the uppercase text.
  2. Type the following formula into the cell: =UPPER(
  3. Enter a text string you want to convert directly in the formula or select a cell containing the text string
  4. The cell should now display the UPPER case version of the input string.



The following picture shows how the UPPER formula converts the original letters into all capitalized letters. 

How to use the UPPER function in Excel

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below