Description
Use this function to convert all the characters in a text string to uppercase. Supported in Chains.
UPPER is useful for standardizing text data to ensure consistency in text processing and comparisons.
Syntax
UPPER(text)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
text |
Yes | The text string that you want to convert to uppercase. | A text string, a reference to a cell containing text, or a formula which results in either of these. |
Example
Sample data
| A | ||
|---|---|---|
| 1 | hello | |
| 2 | world | |
| 3 | inc. | |
| 4 | Workiva |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Convert the text in a cell to all uppercase letters. | =UPPER(A1) |
Converts every character in "hello" to uppercase. Result: HELLO |
| Convert a specific piece of text you type directly into the formula to uppercase. | =UPPER("world") |
Converts the literal text "world" to uppercase instead of pulling from a cell. Result: WORLD |
| Combine text from two cells into one uppercase phrase. | =CONCATENATE(UPPER(A1), " ", UPPER(A2)) |
Converts "hello" and "world" to uppercase individually, then joins them with a space. Result: HELLO WORLD |
| Join text from two cells first, then convert the combined result to uppercase. | =UPPER(CONCATENATE(A4, ", ", A3)) |
Joins "Workiva" and "inc." with a comma and space, then converts the entire combined string to uppercase. Result: WORKIVA, INC. |
Notes
- UPPER doesn't change any non-text characters within the string.
- UPPER can be used with other functions to ensure text consistency in data analysis.
- UPPER is case-sensitive, meaning it will convert all lowercase letters to uppercase but leave existing uppercase letters unchanged.
Tips
- UPPER can be combined with other text functions such as LOWER and PROPER to manipulate text case as needed.
- UPPER can help create standardized data formats, which is useful in data validation and cleanup tasks.
- Use UPPER to prepare text data for case-insensitive comparisons.