Capitalizes the first letter in each word of a text string and converts all other letters to lowercase.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
PROPER(text)The PROPER function is useful for formatting names, titles, or addresses that have inconsistent casing. It treats any character that is not a letter as a word separator, ensuring that the character immediately following it is capitalized.
=PROPER("excel IS FUN")結果: Excel Is Fun
Converts the all-caps string into proper case.
=PROPER("john doe")結果: John Doe
Capitalizes the first letter of both 'john' and 'doe'.
Yes, it treats non-letter characters as separators and capitalizes the letter immediately following them.