For example, column A needs to be sorted, enter =LEN(A 1) in B 1, fill it down to the last row and need to be sorted, and then sort it in ascending order with column B as the primary key.

The sorting method can refer to the following websites:

Office2003 and before:/article/295430f133f8E70c7e0050a 9.html.

Office2007 and later:/article/c275f6a2d7147e33d756781.html.

Supplement to LEN () and LENB ():

The difference between LEN () and LENB () here is that LEN () counts a Chinese character as one character, while LENB () counts a Chinese character as two characters. For example, in the sentence "My number is 123", the result obtained by using the LEN () function is 5, and the result obtained by using the LENB () function is 7. Can be used according to actual needs.