UPPER

Converts a text string to uppercase.

Syntax:

UPPER(text)

returns text with all characters converted to upper case.

Example:

UPPER("Good Morning")

returns GOOD MORNING

Application:

Standardizing Names with the UPPER Function

Let's say you're a HR manager and you have a list of employees. The names have been entered by different people over time, leading to inconsistent capitalization. To ensure that every name is in a consistent format for your records, you can use the UPPER function.

	Employee Name (Raw Data)	Standardized Name (UPPER)	Formula
	A	B	C
1	steven taylor	STEVEN TAYLOR	UPPER(A1)
2	Maria Rodriguez	MARIA RODRIGUEZ	UPPER(A2)
3	AMY CHEN	AMY CHEN	UPPER(A3)
4	david lee	DAVID LEE	UPPER(A4)

Explanation:

Column A shows the raw data, which has a mix of all lowercase, proper case (first letter capitalized), and all uppercase names.
Column B displays the result after applying the UPPER function. No matter how the name was originally entered, the function converts it to all capital letters.
Column C shows the simple formula used in each cell in Column B.

How it's used in the "Standardized Name" column:

In our example, the "Standardized Name" column (Column B) is not manually entered. Instead, each cell contains a formula that references the corresponding cell in the "Employee Name (Raw Data)" column (Column A).

In cell B1: The formula is UPPER(A1). The function looks at the text in A1 ("steven taylor") and converts it to "STEVEN TAYLOR".
In cell B2: The formula is UPPER(A2). The function takes "Maria Rodriguez" and converts it to "MARIA RODRIGUEZ".
In cell B3: The formula is UPPER(A3). The function takes "AMY CHEN" and since it's already in uppercase, it remains "AMY CHEN". This shows that the function is robust and won't alter already-correctly formatted data.
In cell B4: The formula is UPPER(A4). The function takes "david lee" and converts it to "DAVID LEE".