How to sort by number of characters in table

Method: First open the excel table that needs to be operated, click on the specified cell in the auxiliary column; then enter the formula "=len (cell)" in the cell, and press the "Enter key" on the keyboard "; then fill in the auxiliary columns in the drop-down menu, click "Data" at the top of the page, select the specified sorting method; and finally delete the auxiliary columns.

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

Open the excel table, as shown in the figure below. The characters in a column are of different lengths. At this time, what should you do if you want to sort according to the length of the characters.

#If we just simply use sorting to perform the operation, let’s see what the effect is. Find the sorting under the data option. We can see that it is not possible to use sorting alone. It is only sorted according to the first character.

Here we are going to use a function formula. After the table, we create an auxiliary column, the word count column. First, use the formula to calculate the number of words in the cell. , the function is len, which returns the number of text characters in the cell.

In the auxiliary column, we enter the function formula =len(A1), as shown in the figure below. After the input is completed, click Enter and the drop-down menu fills in the formula to get the cell. Number of characters.

Next we can sort the auxiliary columns in the table, locate the auxiliary columns, and find the sort filter under the data option Use the sort button under the tab to select ascending or descending order according to your needs.

You can see that the contents of the front column of the table are sorted according to character length. After completion, just delete the auxiliary column directly.

Related learning recommendations: excel tutorial

The above is the detailed content of How to sort by number of characters in table. For more information, please follow other related articles on the PHP Chinese website!