There are a few different ways that you can modify proper capitalization in Excel. You can use the built-in functions, or you can write your own custom function. Let's take a look at both methods.

Built-In Functions

Excel has a few built-in functions that can be used to modify proper capitalization. The first function is called PROPER. This function will take a string of text and return it with the first letter of each word capitalized. For example, if you have the following text in a cell:

"this is a test"

You can use the PROPER function to return the following text:

"This Is A Test"

The second function is called UPPER. This function will take a string of text and return it with all letters capitalized. For example, if you have the following text in a cell:

"this is a test"

You can use the UPPER function to return the following text:

"THIS IS A TEST"

Custom Function