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