UPPER function: Convert lowercase to uppercase in Excel

Buzz

Ngày cập nhật gần nhất: 15/9/2025

Content

How to use UPPER function in Excel

Guide on how to use the UPPER function in Excel - Illustrated Examples

In Excel, the UPPER function is used to convert text to uppercase, allowing you to easily and quickly change to uppercase without any errors. Refer to the following article to learn how to write the UPPER function syntax correctly.

UPPER function in Excel helps you convert lowercase to uppercase in Excel. With this function, you can save a lot of time and effort when working on spreadsheets.

How to use UPPER function in Excel

Guide on how to use the UPPER function in Excel - Illustrated Examples

Syntax: UPPER(text)

Where: Text: Is the text you want to convert to uppercase.

Consider an Example: You have a column of names all in lowercase

Now, if you want all names to be in uppercase, follow the steps below. Enter the formula in cell E5, and you'll get the result

Drag the mouse to get the result for the remaining cells

So now you know how to use the UPPER function to convert lowercase to uppercase in Excel. Additionally, if you want to capitalize the first letter in a string, you can use the PROPER function in Excel.

Moreover, the TRUNC function is also widely used in Excel. You can refer to the TRUNC function to learn Excel effectively and explore more useful functions.

Frequently Asked Questions

How do I correctly use the UPPER function in Excel?

To use the UPPER function in Excel, enter the formula =UPPER(text) where 'text' is the lowercase text you want to convert to uppercase. This function will quickly change your text without any errors.

What is the purpose of the UPPER function in Excel?

The UPPER function in Excel is designed to convert lowercase text to uppercase. It streamlines data entry, ensuring consistency and saving time when managing spreadsheets.

Can the UPPER function be used for multiple cells in Excel?

Yes, after entering the UPPER function in one cell, you can drag the fill handle to apply the formula to additional cells, converting all specified text to uppercase efficiently.

What alternatives exist for capitalizing text in Excel besides the UPPER function?

In addition to the UPPER function, you can use the PROPER function to capitalize the first letter of each word. The TRUNC function is also useful for various data manipulation tasks in Excel.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]