课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,100 门业界名师课程任您挑！

Bring contents into a single cell

Bring contents into a single cell - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

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…

内容