Sorting Columns by number of characters

N

NicoleS

I'm using Excel 2007.

Is it possible to sort a column by the number of characters on the line?
I track part numbers - which vary in length and can include letters and
hyphens.

Using just sort (smallest to largest) sorts by the beginning numbers.

Being able to do a sort like this could cut down the time it takes me to do
the next step in my tracking.

Thanks!
Nicole
 
F

Fred Smith

Just add a column with the formula:
=len(a1)
then sort on that.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting by number of characters 2
Cannot sort data 6
First Value in Sorted Column is Not Sorted Properly 3
Counting by numbers of Characters in a cell 5
Columns not sorting properly. 2
Sorting in Numerical Order 4
Numerical Sorting 1
Sorting with empty cells 5

Top