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.