How does excel divide multiple contents of a unit into a vertical column?

This problem requires Excel's column function:

Open the excel document you want to column, find the data in the menu bar, and click to open it.

Select the column to be divided first, select all the upper part of the point column, and pay attention to leaving an empty column behind.

Click on the column to bring up the column window, according to the separator.

In this case, the separator is a space.

Tick Other, and enter a space after Other. This space is the separator between the name and ID number in the preceding column. There is also a preview of the data below, and you can see that there is a line separating it.

Tap Next, then Done. That's it. If there is no blank column at the end, it will be overwritten by the data after the column, of course, there will be a hint.

Of course, it can be separated by a fixed width. Just click where you need it.

Here's the result: Attention.

The third step can be set.

Column data format, select the current column as needed.

Format. Whether it's text or regular or date format.

Column, enter in other separators: Hold down the Alt key, then press 10 in the keypad

i.e. soft carriage returns).

There are two ways to do this:

1. Use the "column" function. Select the cells that need to be divided, click the menu "Data" - Column", select "Separator" or "Fixed Width" Column - "Next" according to the actual situation, enter the separator symbol or dot ruler to cut the data in "Other", enter the cell range address where the first number of target data is stored in "Target Area", and finally press "Finish".

Second, use formula functions. It can be handled with functions such as left, right, or mid.

Example: Assuming that the original data is in the form of "12-34-56", you are required to split the data separated by "-" into the next three cells. =trim(mid(substitute($a1,"-",rept(",99)),column(a1)-1)*99+1,99))

Pull right fill.

At work, a column is too long to be displayed on one page, and sometimes it is necessary to divide a column into multiple columns. As shown in the figure, column A has 16 rows, which are divided into 4 columns. Let's talk about the process.

1. Prepare a column of data, where there are 16 rows.

2. Calculate the starting serial number of each new column according to how many columns you need to divide into as many columns. This example is divided into 4 columns, each with a starting number of 1, 5, 9, and 13 respectively.

3. Replace, find "a", replace with "a".

5. Select multiple cells, place the mouse in the lower right corner of the selection area, and the cursor will change to "ten".

6. Drag down to fill the cells. That's all for this method.

As you can see, the data in my excel document has a long paragraph with obvious spaces in the middle, from which it can be split into multiple columns. Note that these data are not in multiple columns, but are all in the first column.

Select the columns you want to split.

Select the Data – Column function in the menu.

There are two ways to split the field in the following window, one is by specifying characters, such as spaces, commas, parentheses, etc., and the other is by specifying a fixed width. Here we select the second option and click on the Next button.

Click the mouse to create a dividing line, and you can move the position of the dividing line left and right to adjust.

There are a total of 108 names in column A in the figure above, which we converted into 6 columns and 18 rows.

Enter :A1 in cell C1 and drag to the right to copy to cell H1;

In cell C2, type: A7, drag to the right to copy to cell H2;

Select the C1:H2 cell range and drag down to copy to row 18;

Select the C1:H18 cell area, press Ctrl+H to find the content, enter :a, replace with input:=a, click the [Replace All] button, and finally [Close] the window to complete the branch division.

Article **302Done with an equal sign.

First enter =A19 in cell b1, then drag to the right to fill 4 columns, and then fill down, so that the first 18 rows are the result we want;

Select these 6 columns, copy, then click the inverted triangle below [Paste], select [Value], and finally delete the content after 18 lines.

Article **503It's done with a function formula.

Enter the formula in cell C1:

offset($a$1,mod(column(a1)+5,6)+row(a1)*6-6,)

Then drag the copied formula to the right to the h1 cell;

Then select the C1:H1 cell area, drag down to copy the formula to row 18, and then you can complete the line division.

Article **6 You have a look at it.

Here's an example.

Column A has 25 data 1-25 Divide them into 5 columns Column 5 data formula: Enter =indirect( in b1"a"&((column(a1)-1)*5+row(a1))), then pull down 5 squares and 5 squares to the right.

Change the above formula to know the total data a, then divide the number of columns b to get the data c of each column, change (column(a1)-1)*5 This formula 5 can be changed to the number of each column 5.

Use this tool, as shown below:

As shown in the figure above, it is divided into 2 points equally, which will be automatically divided and typeset automatically.

The steps of the method are as follows:1. As shown below, select two or two columns of several rows of cells.

2. Then click "Merge" under the "Start" menu, and click "Cross Merge" in the drop-down menu.

3. At this time, the two cells in each row of these two columns will be merged with each other.

Fourth, at this time, adjust the column width of the two columns of BC to the appropriate width.

5. Finally, click on cell B1, and then click on "Merge" again.

6. The final effect is as shown below, the B1 and C1 cells are divided into two, as if they are divided into two.

Ways to create custom number formatting in Excel:

1. Select the cell or range of cells you want to format.

2. Click the "Cell" command in the "Format" menu, and then click the "Number" tab.

3. In the Classification list, click the Custom option.

4. In the Type box, number format to create the desired format.

Select the column where the public search is located to sell early, click "Column" in "Data", and click "Finish" directly in the pop-up dialog box, so that the cells in the selected column that originally displayed the formula will display the formula calculation result.

Tools Raw Materials:

Win10 Microsoft Excel 20191, entered the formula in the Excel cell as shown in the following figure.

2. If the formula only displays the formula itself instead of the calculation result, as shown in the figure below.

3. At this time, you can select the column where the formula is located, and click "Column" in "Data", as shown in the figure below.

4. Click "Done" directly in the pop-up dialog box, as shown in the figure below.

5. In this way, the cells in the selected column that originally displayed the formula will display the formula calculation result, as shown in the figure below.

The contents of excel cells can be displayed in columns, but formulas cannot be displayed in columns. Rent a book.

Step 1: Select the column where the content is located

The steps to divide the contents of a column into multiple columns are as follows:

Operating environment: Lenovo Xiaoxin Stove Shen Air15, Yinfeng Jing Windows10 version, WPS version, etc.

1. Open Excel** and select the data.

2. Click [Data] in the toolbar and click [Column].

3. Select [Fixed Width], click the base year of the position to be split on the page, and click [Next].

4. Click Done.

At work, the content of a column is too long to be displayed on a page, and sometimes it is necessary to divide a column into multiple columns to arrange. As shown in the figure, column A has 16 rows, which are divided into 4 columns. Let's talk about the specific process.

1. Prepare a column of data, where there are 16 rows.

2. Calculate the starting serial number of each new column according to how many columns you need to divide into as many columns. In this example, the book is divided into 4 columns, and each column starts with the serial number 1, 5, 9, and 13 respectively.

3. Replace, find "a", replace with "a".

5. Select multiple cells, place the mouse in the lower right corner of the selection area, and the cursor will change to "ten".

6. Drag down to fill the cells. That's all for this method.

Open Excel and select the columns you want to sort.

Click on "Data" in the menu bar, and then click on "Columns".

Select "Dividing Symbol" in the pop-up dialog box, and then click "Next".

Select the appropriate separator, or click "Other" to enter the separator manually.

Click "Next" and select the column data format, such as General, Text, Date, etc.

Click "Done" so that you can split a column into multiple columns.

The above steps may be slightly different depending on the version, please adjust Yanhong according to the actual situation. Fu Zaochang.