Home > Greek translator, Μεταφραστής, Σπύρος Δόικας, Microsoft Excel, Spiros Doikas, Translation, Translator > Sorting a column on the number of characters in cells (Excel)

Sorting a column on the number of characters in cells (Excel)

If you have 2 columns with data, say A and B. On column C, cell 1 enter =LEN(B1) if you want to count on the basis of the number of characters in column B, or =LEN(A1) if you want to count on the basis of the number of characters in column A.

After you enter that on the cell, press ENTER and then place the mouse on the corner of the cell and drag down to copy the formula.

Then select the column with the counts and click Sort.

  1. progvamp
    September 14, 2009 at 6:00 am

    Thanks! Very useful tip! Keep it up!😉

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: