說明
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.
語法
UPPER(text)
Inputs
This function accepts the following arguments:
| 名稱 | 必要 | 說明 | Valid input |
|---|---|---|---|
文字|收發簡訊 |
是 | 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. |
範例
Sample Data
| A |
|---|
| hello |
| world |
| inc. |
| Workiva |
Sample Formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=UPPER(A1) |
Converts the text in cell A1 to uppercase. | HELLO |
=UPPER("world") |
Converts the string "world" to uppercase. | WORLD |
=CONCATENATE(UPPER(A1), " ", UPPER(A2)) |
Joins the text in cell A1 with the text in cell A2, and converts the joined text to uppercase. | HELLO WORLD |
=UPPER(CONCATENATE(A4, ", ", A3)) |
Joins the text in cell A4 with the text in cell A3, and converts the joined text to uppercase. | WORKIVA, INC. |
附註
- 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.
提示
- 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.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER