In this article, you will learn how to use the UPPER formula 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.
The UPPER formula can be a useful tool for formatting, cleaning, and standardizing text in Excel. Some common uses can be as below:
The following picture shows how the UPPER formula converts the original letters into all capitalized letters.
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.
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 👇