From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Bring contents into a single cell

Bring contents into a single cell - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Bring contents into a single cell

“

- [Instructor] Let's get into formatting in Excel. We have these names from day one through day six, and we have a list of groups. Purple group has Nathan all the way through Lily. Every day has a filled slot. But Crimson is missing two names. Rose Red group is missing three names. So here's what we need to do. In column C, bring all of the names into a single cell with space-asterisk-space as the delimiter. So we want all six of the names in the Purple group in cell C2 with space-asterisk-space between every name. But now, when we get to the ones with the missing names, we still want to have a space for those. If there are two names next to each other that are missing, you're going to have space, asterisk, space, space, asterisk, space. All right? Okay. Hopefully, you get the picture. All right. And then use Word Wrap, so that we can see all of the names. And you're going to have to widen column C and adjust the row…

Contents