Sort list of data by Character count in Excel


Here’s a quick and highly useful tip to sort a long list of data based on Character count in Excel. Although there is no excel feature to directly sort by character count, this ultra simple work-around will help you sort column by number of characters in cell. This tip may be very helpful to people working with large amount of data, file list or whatever.

Step 1: Let us say, your data is in Column A, now in column B simply write the formula to find word length, Formula will be =LEN(A1)



Step 2: Now drag or double click the tiny box in the formula cell to apply this formula to all cells in the column



Step 3: Highlight the column, and in the Home tab, select “Sort & Filter” > “Sort Smallest to Largest



Step 4: Select “Expand the selection” and click “Sort



Step 5: Done, now all your Data in column A should have been sorted out based on Character count, now you can delete the temporary character count column.



Abilash A

I am a Web and Graphic designer, specializing in designing and hosting websites, blogs and forums. I love technology and blogging is my passion. I also specialize in blogger to WordPress migration. Currently I work Full-Time as a Quality Control and Testing Engineer.