From the course: Excel: Advanced Formulas and Functions
Join today to access over 23,200 courses taught by industry experts.
UPPER, LOWER, and PROPER
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.