How To Reformat Your Spreadsheet To Title Case
If you are wanting to to use data in a spreadsheet for a message, but the words in your column are all capitalized or all lower case. This article explains how to reformat your data so that they are Title Case.
If you are wanting to to use data in a spreadsheet to automate a message step in the desktop app but data (words) in your column are all capitalized or all lower case. This article explains how to reformat your data so that they are Title Case. Start with highlighting all of the columns that you want to title case. Examples shown below.
Next, open a blank google doc and paste the data to the empty sheet. Example shown below.
Next, highlight the data pasted if it’s not already. The click format
and hover over text
. Shown in the picture below.
When hovering over Text
a new window will open. Scroll down and hover over Capitalization
. Then click Title Case
. Highlighted in the picture below.
Now all of your data should be set to Title Case
.
Next, highlight all of the data from the google sheet that is now in Title Case format and paste into a new column in the original google sheet.