UPPER function, convert lowercase to uppercase in Excel

UPPER function, convert lowercase to uppercase in Excel


In Excel, the UPPER function is a function that converts text to uppercase in Excel, allowing you to convert it to uppercase easily and conveniently without any errors. If you do not know how to use UPPER function, you can refer to this article.


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

How to use UPPER function in Excel?

Instructions on how to use the UPPER function in Excel – Example illustrations

Syntax: UPPER (text)

Inside: Text: The text you want to convert to uppercase.

Consider Example: You have a column of first and last names lowercase

convert bar to excel in excel

Now you want your full name to be in uppercase, you do as shown below. Enter the formula in the cell E5, we get results

ham upper, convert the bar to excel in excel

Drag and drop to get the results for the remaining cells

ham upper in excel

https://thuthuat.taimienphi.vn/ham-upper-trong-excel-2374n.aspx
So you already know how to use the UPPER function to convert lowercase to uppercase in excel already. Alternatively, if you want to convert the first character in the string to uppercase, you can use it PROPER function in Excel.

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *