How to use the UPPER Function in Excel

Description

The UPPER Function is categorized as Text Function in Excel. This function converts all given text strings to uppercase.It do not affect the punctuation, spaces, special characters and the text string which are already in uppercase. But it will convert number as text and it will remove all number format.

The UPPER function takes one argument which can be a text string or any cell reference. It can also be used as a part of a formula. We can use this formula to organize large volume of text.

Syntax

The syntax of UPPER function is =UPPER(text)

Argument or Parameter

text- can be a text string or cell reference which we want it to be in uppercase text.

Returns

The UPPER returns text strings in uppercase from a given text string.

Example

Example-1

We have provided different types data which contains text having text string in uppercase, lowercase. Numbers with different number format. We have also added punctuation and special character. All the data are in A column and we used Upper function is used column B, we can see the results in column B. See the image below.

Example-2

Suppose we have imported external data in column A and column B. We can see the data in column is unorganized, different text are in different type case and we need to convert it into uppercase. So what we have to do is, select cell C2 and type =UPPER(B2 ) and press Enter. Then drag the fill handle of cell C2 till the last cell of the data. All the data will be converted to uppercase at a time.

Notes

All lowercase text will be converted to uppercase text.
Uppercase text will remain unaffected.
Formatting of standalone numeric value will be removed.
Upper case function can used as a part of formula.

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Free

If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..

************************************************************************************************

TEXT FUNCTIONS FUNCTIONS
BAHTTEXT	CHAR	CLEAN	CODE	CONCATENATE
DOLLAR	EXACT	FIND	FIXED	LEFT
LEN	LOWER	MID	NUMBERVALUE	PROPER
REPLACE	REPT	RIGHT	SEARCH	SUBSTITUTE
T	TEXT	TRIM	UNICHAR	UNICODE
UPPER	VALUE