If you want the first letter of every word to appear in upper case, you can use the Change style to Title case function.
Tip: This transformation can also be performed by using the Magic fill function.
Procedure
-
Select a column containing text for which you want every word to start with an
upper case letter.
-
In the Functions panel, type Change to title
case and click the result to execute the associated function.
Results
Every word starts with a capital letter in the selected column.
