Aus dem Kurs: Excel 2016: Advanced Formulas and Functions

So erhalten Sie Zugriff auf diesen Kurs

Werden Sie noch heute Mitglied und erhalten Sie Zugriff auf mehr als 23.100 Kurse von Branchenfachleuten.

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

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

Aus dem Kurs: Excel 2016: Advanced Formulas and Functions

Gratismonat starten Für Ihr Team erwerben

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…

Inhalt