Capitalizes the first letter in each word of a text string and converts all other letters to lowercase.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน 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.