From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Combine first and last names

Combine first and last names - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Combine first and last names

“

- [Instructor] Today you and I wanna print some labels, and it would be so helpful if we could get the first and last names together in one column. Get the first and last names together, but also pay attention to the cases. Notice Stephanie Richards. The S is small. Lonnie Minter is all caps. So please pause the video, get the names put together and please do not type 'em. Then come back and I will show you a solution. Okay, you're back. Let's jump in, and I am gonna take advantage of a feature called Flash Fill. I'll go up here to F2 and type Denise Santiago. Enter. Now Paulette Richards. Flash Fill is making a guess for us. Do we want the names put together? Yes, we do, but they're still messed up. Stephanie Richards still has a small S. So let me finish Paulette Richards. I've gotta train Flash Fill a little bit. Let's go to Stephanie Richards. Enter. Next, we wanna respect the capital D in McDonald.…

Contents