Sort list of data by Character count in Excel

Sort-Data-based-on-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)

Character-Count-in-Excel

 

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

Charachter-Count

 

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

Sort-in-Excel

 

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

Expand-the-Selection

 

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.

Data-Sorted-in-excel-Based-on-Number-of-Characters

 

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.