Google Sheets Function: PROPER

The PROPER function capitalizes the first letter of each word and makes all others lowercase.

Usage:

=PROPER(text)


Usage Example

Enter the PROPER function and choose the text to be converted to proper case:

=PROPER(A2)
google sheets proper function

The result of this function after copying:

google sheets proper function copied