Excel Guides

Specifying Proper Case in Excel

When it comes to specifying proper case in Excel, there are a few different methods that you can use. Each has its own set of pros and cons, so it's important to choose the one that will work best for your needs. Here's a look at some of the most popular methods:

1. The PROPER Function

The PROPER function is probably the most popular method for specifying proper case in Excel. It's a built-in function that's designed specifically for this purpose, and it's very easy to use. Simply enter the text that you want to convert into the function, and it will return the text with the first letter of each word capitalized. For example:

PROPER("this is some text")

will return "This Is Some Text".

One downside of the PROPER function is that it doesn't handle apostrophes very well. For example, if you have a word like "don't", it will return "Don'T" - which is probably not what you want. In cases like this, you'll need to use a different method.

2. The UPPER Function

The UPPER function is another built-in Excel function that can be used for specifying proper case. It's similar to the PROPER function, but instead of capitalizing the first letter of each word, it converts all letters to uppercase. For example:

UPPER("this is some text") 

will return "THIS IS SOME TEXT".

Like the PROPER function, the UPPER function doesn't handle apostrophes very well. So if you have a word like "don't", it will return "DON'T". Again, in cases like this you'll need to use a different method.

3. The LOWER Function

The LOWER function is basically the opposite of the UPPER function - it converts all letters to lowercase. So:

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.