分享兴趣，传播快乐，增长见闻，留下美好!亲爱的您，这里是LearningYard新学苑。今天小编分享的是文本分列。欢迎您的访问！
Share interests, spread joy, grow insights, and leave behind goodness! Dear you, this is LearningYard New Learning Academy. Today I am sharing text disaggregation. Welcome to visit!
本期推文包括思维导图与正文内容。欢迎阅读！
This tweet consists of a mind map and body content. Welcome to read!
如果，你有一列数据如下，某个单元格中的内容包含年龄和部门，中间用空格隔开，如 “30 销售部”。你想要把那一列内容分列展示，应该如何操作呢？
If, for example, you have a column of data as follows, and the contents of a certain cell contains age and department separated by a space, such as “30 Sales”. You want to show the contents of that column separately, how should you do it?
当文本的格式比较统一时，比如下表两项信息间是由空格所间隔开，我们需要用到excel的一个功能：数据分列。
When the text of the format is more uniform, such as the following table between two pieces of information is separated by a space, we need to use excel a function: data breakdown.
具体如何操作呢，一起来看一下吧。
Specifically how to do it, together with a look at it.
第一步：选中要进行内容分列的单元格。点击数据-分列，此时会弹出一个文本分列向导的第一步，总共三步。
Step 1: Select the cell where you want to disaggregate the content. Click on the data - divided, this time a text will pop up the first step of the Wizard, a total of three steps.
当文本的格式比较规范，比如 空格，我们点击“分割符号”，然后点击下一步。
When the text format is more standardized, such as space, we click on the “split sign”, and then click Next.
在弹出的分列向导第2步中点击“空格”，下一步。
Click on “Space” in Step 2 of the Disaggregation Wizard pop-up, Next step.
在弹出的分列向导第3步中点击“常规”，下一步。
Click on “General” in step 3 of the pop-up disaggregation wizard, and proceed to the next step.
至此，文本内容就被分好啦。
At this point, the text content is divided.
今天的分享就到这里了，如果您对文章有独特的想法，欢迎给我们留言。让我们相约明天，祝您今天过得开心快乐!
That's all for today's sharing. If you have a unique idea about the article, please leave us a message, and let us meet tomorrow. I wish you a nice day!
参考资料：ChatGPT、百度百科
本文由LearningYard新学苑整理并发出，如有侵权请在后台留言沟通！
文案｜Rue
排版｜Rue
审核｜ hong
Learning Yard 新学苑