From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Adjusting text entries with the UPPER, LOWER, and PROPER functions

Adjusting text entries with the UPPER, LOWER, and PROPER functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Adjusting text entries with the UPPER, LOWER, and PROPER functions

“

- [Instructor] When you work with texts in Excel there are times when you want entries to be lowercase, sometimes upper case, sometimes a mix. Often like in column A, it would make sense to have these letters be uppercase. They just tend to look better. Some of them are, some of them aren't. Let's adjust them all, using an Excel function called, upper. And I'll do this in column B. We could approach this a couple of different ways. We could highlight all the cells ahead of time, and simply write the function equal upper. As you type it, it doesn't have to be upper case of course. Left parenthesis. I'll click on cell A two, but instead of pressing enter, since I've got all these cells highlighted, I'll press Ctrl + Enter there we are. And if we want to move these into column A, all we need to do... And a nice shortcut here by the way is, without going through multiple steps, we'll simply point to any edge of this…

Contents