Tuesday, October 26, 2021

Warning: Undefined variable $bg_color in /home/u434284273/domains/thetechgears.com/public_html/wp-content/plugins/gs-facebook-comments/public/class-wpfc-public.php on line 258

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.



Related Articles


Please enter your comment!
Please enter your name here

2 × five =

Most Popular

You'll like these