How do you sort the data in an excel sheet?

To give you a sample file, each corresponding function is a separate one.

if(int(a2/10000)=0,"",int(a2/10000))

if(int(mod(a2,10000)/1000)=0,"",int(mod(a2,10000)/1000))

if(int(mod(mod(a2,10000),1000)/100)=0,"",int(mod(mod(a2,10000),1000)/100))

if(int(mod(mod(mod(a2,10000),1000),100)/10)=0,"",int(mod(mod(mod(a2,10000),1000),100)/10))

if(int(mod(mod(mod(mod(a2,10000),1000),100),10))=0,"",int(mod(mod(mod(mod(a2,10000),1000),100),10)))

if(int(round(a2-int(a2),2)*10)=0,"",int(round(a2-int(a2),2)*10))

if(round(a2-int(a2),2)*100-(int(round(a2-int(a2),2)*10))*10=0,"",round(a2-int(a2),2)*100-(int(round(a2-int(a2),2)*10))*10)

Fill in the digits with 0 and intercept them with the mid function.

Select the data area to be divided, click "Column" in the "Data" option, then select "Fixed Width", drag the segmentation line to split the data, and click "Target Region" to select the placement area after the data splitting, detailed steps:

1. Select the data area to be columned, and click "Column" in the "Data" option.

2. Then check "Fixed Width" and click "Next".

3. Drag the split line to split the data, and then click "Next".

4. Click "Target Area".

5. Select the area where the data will be split and click OK.

6. Then click "OK" again.

Method 1: Determine whether there are separators in the middle, such as commas, quotation marks, etc., and complete the operation on the "data"-column-separator;

Method 2, fixed width, data-column-fixed width, appropriate adjustment distance, and complete it according to the steps.

If there is anything else after this column of data, remember to insert the empty column first to avoid replacing and overwriting the following data.

Select the data and directly click on the data column. Different versions are different, find them yourself, and then follow the prompts to do it.

Select the data area to be divided, click "Column" in the "Data" option, then select "Fixed Width", drag the segmentation line to split the data, and click "Target Region" to select the placement area after the data splitting, detailed steps:

1. Select the data area to be columned, and click "Column" in the "Data" option.

2. Then check "Fixed Width" and click "Next".

3. Drag the split line to split the data, and then click "Next".

4. Click "Target Area".

5. Select the area where the data will be split and click OK.

6. Then click "OK" again.

Use the "Breakdown" function to:

1. The data in the excel document has a long paragraph and there are obvious spaces in the middle, which can be divided into multiple columns from these spaces. Note that these data are not in multiple columns, but are all in the first column.

2. Select the column you want to split. Select the Data – Column function in the menu. There are two ways to split a field, one is by specifying characters, such as spaces, commas, parentheses, etc., and the other is by specifying a fixed width.

Select the second option here and click the Next button.

3. Click the mouse to establish the dividing line, and you can move the position of the dividing line left and right to adjust. When you're done creating a divider, click Done.

4. Click on the first column, which shows the very short data in the column, indicating that the long data has been divided.

1.Step 1: Open the ** that needs to be sorted, select the ** data that needs to be sorted, and click "Data" in the upper menu;

3.Step 3: Check the "Other" in the column symbol, and enter the "-" symbol in the box to the right of it, then you will see that the preview below has changed, and finally click "OK" to complete the column!

1. Find the Excel quick letter icon on the desktop and click, right-click on the excel shortcut icon, click open in the right-click menu, and open the excel software, as shown in the figure

1. Open Excel**.

2. After opening Excel**, click to enter the data page.

3. Click to enter the data page, and then click Columns.

4. After clicking on the column, check the separator symbol, and then click Next.

5. After clicking Next, check Other, then enter a comma and click Next.

6. Finally, click Done.

7. After clicking on the completion, the data will be divided into columns according to the position of the comma.

The first step is to click the [Column] button under [Data].

Select a column splitting method, and select a separator or a fixed width as needed

Examples of width:

Example of a separator:

Finally, you can click the [Done] button.