Technology

Database Quick Tips: Capitalizing Contacts

March 9, 2017

Sometimes your database needs a little scrubbing. If you are planning to use any variable tags to personalize your database email marketing, having capitalized first and lasts name is key. You probably don't have all day to manually check each of your contacts, but by using this quick Google Sheets hack, your contacts will be capitalized and ready to go in no time.


Step 1:

Load your contacts into Google Sheets. If you don't have a GSuite account, you can sign up for one here. You can either import a CSV or Excel file, or copy and paste your data into a new spreadsheet.

lowercase name in single google sheets column

Step 2:

In the cell at the top of the column next to your data, type "=proper (A1)", and hit enter. You may have to change the A to correspond with the letter that labels your data column. Your first cell should now be repeated in the cell with the formula, but with a capital letter.

google spreadsheets capitalize letter formula

Step 3:

Hold down shift and at the same time, drag the crosshairs down the entire column next to your data.

use google sheets capital letter formula on entire column

Step 4:

Release the mouse and release the shift key at the same time. Your data should now fill the next column. Now sit back and marvel at those capitalized names.

capitalize words in google sheets


Want a chance to win a Tesla?

Refer an Agent
News From Our Blog

Related Posts

Village LifeRenting vs. Buying

Renting vs. Buying

The question of renting or buying can be a complicated one. It depends on a number of factors, and there's no blanket answer to which one is better for you. Your financial situation, personal preferences, area you live, and more all play a part. Let's look at the pros and cons of both.

Village LifeFourth of July in Atlanta

Fourth of July in Atlanta

Last year a lot of 4th of July celebrations were cancelled or postponed. That means we need to make up for lost time this year! Luckily the Atlanta area has no shortage of ways to celebrate the birth of our nation.

Village LifeHow long are homes staying on the market?

How long are homes staying on the market?

If you're going to help your clients buy and sell homes, you have to understand how fast the market is moving right now.

View all the latest blog posts