Converts all characters in a text string to uppercase.
Söz dizimi
UPPER(text)Bağımsız değişkenler
textzorunlu
The text you want to convert to uppercase.
The UPPER function takes a text string as input and returns the same string with all lowercase letters converted to uppercase. Characters that are not letters, such as numbers and punctuation, remain unchanged.
=UPPER("hello")→HELLOConverts the lowercase word 'hello' to uppercase.
=UPPER("Excel 2024")→EXCEL 2024Converts letters to uppercase while leaving numbers and spaces unchanged.
Select a cell
Click on the cell where you want the uppercase result to appear.
Enter the formula
Type =UPPER( followed by the cell reference or text string, and close with a parenthesis.
Press Enter
Press the Enter key to display the converted text.
No, the UPPER function only affects alphabetic characters and ignores numbers, symbols, and spaces.