From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions

Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions

“

- In this worksheet called Proper, I've got a list of names in Column A. And nothing really wrong with them, except they're all uppercase. It tends to be easier to read the data when only the first letters are capitalized and that's typically how we write or if we're even using cursive, we capital people's names, but only the first letter. So how do we make a change here? On the Formulas tab of the ribbon, under Text Functions, there are three functions related to upper and lowercase. And also one for what we'd call proper case. Here's lower. It converts all letters in the text string to lower case. Sure enough, we've got upper. Opposite, of course. Converts them to uppercase. And then there's proper. It converts a text string to proper case. The first letter in each word becomes uppercase; the other letters are lowercase. And by the way, to extend this definition a little bit, any letter that follows punctuation or a space will be capitalized. So as we look at that list to the left…

Contents