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.
-
Repeat this action for every column you want to modify.
You have the possibility to output the result of this function in a new
column by selecting the Create new column check
box.
Results
Every word starts with a capital letter in the selected column.