Proper function and it's imperfection in Excel

Upper, Lower and Proper function allow us to deal with messy letter case in Excel.

The Upper() function allows us to convert all lowercase letters in a text string to uppercase.

The Lower() function helps to exclude capital letters in a text string.

The Proper() function makes the first letter of each word capitalized and leaves the other letters lowercase.

There are however some imperfections for the proper functions.

One of the imperfection is that when we try to convert string that contain apostrophe s, it also convert the small letter s to big letter s.

The second imperfection of the Proper function is that when a sentence contain I or II that represent one or two, for example, when we are referencing a movie, Spiderman II, it convert the II into ii.

The third imperfection of the Proper function is that when we are converting text string that contain state code, it will also convert the state code into small letter, example, from California, CA to California ca.

The workaround for these imperfection will be using the Proper function together with the Substitute function.

Check out the video to learn in detail on the Upper, Lower and Proper function.