Excel: Change Text to Proper Case

Here's a handy function for you, if you ever find yourself with a a lot of data that isn't in the right case. The "PROPER" function in Excel will let you convert text into a format that capitalizes the first letter of every word, and makes the rest of the letters lowercase. I last used this when I was given a spreadsheet full of names that were in all caps, but I needed to use them in proper case for a mail merge.

So let's say that cell A1 contains the text "JOHN DOE". How do we get this to look like "John Doe"? In another cell, perhaps B1, put in this formula:


You'll see that it will take whatever is in cell A1 and convert it to proper case.


Post a Comment