Capitalize First Letter
Capitalize First Letters in Google Sheets with PROPER + ARRAYFORMULA
The script explains how to capitalize the first letter of each word in Google Sheets to clean up text like product tags, city/location names, part names, names in columns, sheet tabs, and headers. It contrasts UPPER (all caps) and LOWER (all lowercase) with Excel’s “title case,” noting that Google Sheets uses the PROPER function for title casing even though the name may seem misleading. It then shows a shortcut for applying PROPER to an entire column by wrapping it in ARRAYFORMULA and changing a single-cell reference (e.g., B3) to a column range (e.g., B3:B) so the formatting automatically fills down the column.
00:00 Why Capitalize Text
00:37 Upper Lower Proper
00:53 Proper Function Explained
01:19 Capitalize Whole Column
01:37 Subscribe And Next Steps