How to split the contents of a cell into multiple cells

How to split the contents of a cell into multiple cells: First open Excel and select the column "B" that needs to be split; then click "Data" in the menu bar; then find "Data" and click "Column"; finally select "Split Symbol" to split.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Recommended: "Excel Tutorial"

Open Excel, as shown in the figure, when we need to split the cells in the time column.

#First, select the column "B" we need to split, as shown in the picture.

After selecting, click "Data" in the menu bar, as shown in the picture.

After finding "Data", click "Column". as the picture shows.

After clicking, the "Text Column Guide - Step 1" will pop up. as the picture shows.

After it pops up, we select "Separation Symbol" here. as the picture shows.

After selecting, click "Next". as the picture shows.

After clicking, the "Text Column Guide - Step 2" pops up. Here we select "space" as the dividing symbol. as the picture shows.

After selecting, click "Next". as the picture shows.

After clicking, the "Text Column Guide - Step 3" pops up, and we find that the data preview below the pop-up box has been divided according to our requirements. as the picture shows.

Finally, click "Done". Our cells are now split.

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