Column: Split the contents of an Excel cell into two columns

Summary: the processing of Excel data sometimes need to split the contents of the cell into two columns, may be convenient for external software links, may make the data display more clear and so on, some people say that the direct cut and paste is not OK, but sometimes too much data, so processing is inefficient, The method of online search said that inserting such a function can be achieved, but it may seem more complex, in fact, Excel software itself with a "broken down" function.

Example: Excel has a column of content as follows (its composition: Model + Chinese name):
φ1080xφ910x16 cloth
φ1280xφ1100x20 Rubber Racket
φ300x20 Red cloth temperature-resistant glue pat
φ320x20 Green Cloth

... (If there is a later)

Now want it to take the model and Chinese characters separately, separate into a column, that is: the model into a new column, the Chinese name of the product becomes another new column.

Method Step:1, if the data has been entered, then the need to separate the characters between the space, comma, semicolon, or other symbols (such as-)

This is the original data

Add Space before text
2. Select the range of cells that need to be broken down, click Data-Columns, pop-up Columns dialog box

3. Select the separator symbol, then next, tick the space, then a preview of the data columns below, such as:

4, select the column data format and target area, click Finish, appear effect

5. Final effect

Description: 1, the delimiter can be arbitrarily added, such as spaces, commas, semicolons,-and so on, if you want to be divided into 3 columns or more, you can add 2 or more separators between characters;

2. If you want to fix the length of the cell character, select "Fixed width" in the 2nd step, then manually pull the width benchmark next.

Column: Split the contents of an Excel cell into two columns