PROPER

The function PROPER returns a string with a uppercase letter at the beginning of each word. While cleaning your data, the functions PROPER and TRIM can be of good use to create some consistency.

=PROPER(Text)

or..

=PROPER(B3)

=PROPER(“HELlo jULia”)

The video gives an example of how to combine the TRIM and PROPER functions.

Design a site like this with WordPress.com
Get started