# Excel UPPER Function

Home ➜ Top 100 Excel Functions with Examples – A Complete List Including Samples Files ➜ **How to use UPPER Function in Excel (Example + Sample File)**

**What is EXCEL UPPER FUNCTION**

The Excel UPPER Function is listed under Microsoft Excel's Text Functions category. **It returns the string after converting all the letters in the capital.** In simple words, it converts a text string where all the letters you have are in capital letters, numbers will stay intact.

**How to use it**

To learn how to use the UPPER function in Excel, you need to understand its syntax and arguments:

**Syntax**

UPPER(text)

**Arguments**

**text:**The text which you want converts to uppercase.

**Notes**

- Characters other than alphabets remain unchanged.
- If the referred text contains an error it returns an error in the result.
- You can also insert text string directly into the function by using double quotation marks.

**Example**

To master the UPPER function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used the UPPER to convert name text to capital letters from the text in which characters are in different cases.

**Hey Listen,**

You can some Excel Basics Tutorials from this page and here we have Top 100 Excel Tricks and Tips for you get better at Excel in no time.

## Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

**About the Author**

**Puneet Gogia**

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS