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.

Notion image
 
 

Next, open a blank google doc and paste the data to the empty sheet. Example shown below.

Notion image
 
 

Next, highlight the data pasted if it’s not already. The click format and hover over text. Shown in the picture below.

Notion image
 
 

When hovering over Text a new window will open. Scroll down and hover over Capitalization. Then click Title Case. Highlighted in the picture below.

Notion image
 
 

Now all of your data should be set to Title Case.

Notion image
 
 

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.

💡
If you need to split the first name and last name into separate columns. Go to How to Split First & Last Names Into Separate Columns For Your Google Sheet.
 
 
 
Did this answer your question?
😞
😐
🤩