この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
UPPER(text)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")結果: HELLO
Converts the lowercase word 'hello' to uppercase.
=UPPER("Excel 2024")結果: EXCEL 2024
Converts letters to uppercase while leaving numbers and spaces unchanged.
No, the UPPER function only affects alphabetic characters and ignores numbers, symbols, and spaces.