How to split cell content

How to split the cell content: first select the cell, enter the data column, and click the column option; then check the delimiter symbol, click Next; finally check the space and general options, and click Finish. .

The operating environment of this article: windows10 system, microsoft office excel 2010, thinkpad t480 computer.

The specific method is as follows:

First we enter some data in the excel table. For example, I enter the name and scores here, separated by the space bar.

Select the data-click data options-select columns.

In the Text Splitting Wizard 1, select the delimiter and next step.

In the Text Sorting Wizard 2, check the box and click next.

In the Text Splitting Wizard 3, select General and click Finish.

Looking at the final effect, I found that one cell has been divided into two cells.

Related recommendations: excel basic tutorial

The above is the detailed content of How to split cell content. For more information, please follow other related articles on the PHP Chinese website!