Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Sort Excel Cells by the Number of Characters

Date:2019-9-26 Author:Cordelia

If most of the data in an Excel spreadsheet is text, and each cell has a different length of content, it may look untidy on the whole. For this situation, you can sort these cells by the number of characters.

But as you know, there’s no such an existing sorting rule to use directly. Before sorting, you should count the characters number in each cell first.

1. Create a new column aside and name it as you like.

How to Sort Excel Cells by the Number of Characters

2. Input the formula: =LEN(B2) in C2 to count the characters number of the text in B2.

How to Sort Excel Cells by the Number of Characters

3. Press [Enter] key to see the result.

How to Sort Excel Cells by the Number of Characters

4. Use fill handle to apply the formula to other cells.

How to Sort Excel Cells by the Number of Characters

5. Click any cell in the table. Go to Data tab and click the AZ icon (which is Sort Smallest to Largest).

How to Sort Excel Cells by the Number of Characters

6. Or you can click Sort and choose to Sort by Characters (header of column C) in the Order from A to Z.

How to Sort Excel Cells by the Number of Characters

7. Then the data in the table will be re-sorted by the values in column C (also the character numbers of column B) from smallest to largest.

How to Sort Excel Cells by the Number of Characters

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *