Share interests, spread happiness, increase knowledge, and leave a good stay! Dear you, this is LearningYard. Today, the editor is sharing the text column. Welcome to visit!
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 issue of Tweets includes a mind map and body content. Welcome to the reading!
This tweet consists of a mind map and body content. Welcome to read!
If, you have a column of data as follows, the content in a cell contains age and department, separated by a space in between, such as "30 Sales". What do you want to do if you want to display the contents of the column separately?
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?
When the format of the text is relatively uniform, for example, the two pieces of information in the following table are separated by spaces, we need to use a function of Excel: data columns.
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.
Let's take a look at how to do it.
Specifically how to do it, together with a look at it.
Step 1: Select the cells you want to divide the contents into. Click on Data - Column, and the first step of the Text Column Wizard will pop up, for a total of three steps.
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 is formatted in a more formal way, such as spaces, we click on "Split Symbol" and then click Next.
When the text format is more standardized, such as space, we click on the “split sign”, and then click Next.
Click "Space" in step 2 of the column wizard that pops up, and then click Next.
Click on “Space” in Step 2 of the Disaggregation Wizard pop-up, Next step.
Click "General" in step 3 of the pop-up column wizard to next step.
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.
At this point, the text content is divided.
That's all for today's sharing, if you have unique ideas for the article, welcome to leave us a message. Let's meet tomorrow and wish you a happy day!
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、百度百科
This article is organized and issued by LearningYard, if there is any infringement, please leave a message in the background to communicate!
Copywriting |
Typography |
Audit | hong
Learning Yard 新学苑