From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Identify multipart last names

Identify multipart last names - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Identify multipart last names

“

- [Instructor] Here's something that you can do a lot of different ways, and the main thing is the result. We want to look at the column of last names and identify the ones that have two or more parts, like de la Croix. There are three parts there. Odom Dorsey, two names. What about Rhodes-Graham? Yes, we want to consider those two different parts and then don't get hung up on le Blanc and LeBlanc. Angel chooses to put a space between le and Blanc. Miles opts not to. So we want to go with what they've chosen. Miles spells it with just one part. So go ahead, pause the video, identify those multi-part names, come on back, and I'll do it. (upbeat music) Are you ready? There's so many ways to do it. Let's try it this way. I'm going to highlight the names and then go to Conditional Formatting, Highlight Cell Rules, Text That Contains, space. (laughs) Look at that. Okay, and then I'm going to add another rule.…

Contents