Google Sheets Tip - Capitalize Names Quick

Here's how to quickly capitalize all names or cells in sheets.

Type in the follow formula. In this instance A2 is the cell you want to capitalize.

=PROPER(a2)

Then click on the name and drag.