From the course: Excel: Advanced Formulas and Functions
Join today to access over 25,600 courses taught by industry experts.
UPPER, LOWER, and PROPER - Microsoft Excel Tutorial
From the course: Excel: Advanced Formulas and Functions
UPPER, LOWER, and PROPER
- [Instructor] When we're working with data, it can show up in all kinds of ways that require some type of cleanup. Here we're going to go through upper, lower, and proper. And what I really want to get at is to show you some traps, some things to watch out for. Let's look at the data real quick. We've got the name of a hotel, "apple hotel, shoreline." "AuraLaura Studios." "celia hornet," all lowercase. Got "de la Croix." Lowercase D, lowercase L, capital C. "Dubuffet." "ronald g. murray" is all lowercase. "Tatum" is proper case, but then "KEYES" is all caps. So let's go and do an upper. What I really want to do right now is put this into a table. I'm going to highlight here and then go Home, Format as Table. Let's grab this nice green apple color. Okay, table does have headers. All right, good. Get rid of the filter buttons. Click here. Upper equals upper, open parentheses. Highlight the value. Enter. Let's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.