Home  >  Article  >  Topics  >  How to split the contents of a cell into multiple cells

How to split the contents of a cell into multiple cells

藏色散人
藏色散人Original
2020-12-22 14:03:21195100browse

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.

How to split the contents of a cell into multiple cells

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.

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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.

How to split the contents of a cell into multiple cells

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

How to split the contents of a cell into multiple cells

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn