Proper case names in Excel

I recently had a question from someone asking if there was a way to take a column of names in Excel that were in all upper-case and convert them to proper case. In Word, it’s just a menu option, but that feature doesn’t exist in Excel. However, you can get there with an Excel formula. Here’s how…

Here’s my list of names in Excel:

excel-propercase-20190515-1

I place my cursor in cell B1, and type in =PROPER(A1). This means that it will take the contents of cell A1 and convert the text to proper case:

excel-propercase-20190515-2

Once that’s done, I can click in another cell, and I see that cell B1 has the proper case version of cell A1:

excel-propercase-20190515-3

To easily apply that to all the other cells in column B, just click the Fill Handle in the lower right corner of the cell, and drag it down as far as necessary. Now all the values in column A will show with proper case in column B:

excel-propercase-20190515-4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s