LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Sorting Columns by number of characters

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

Regards,
Fred

"NicoleS" wrote in message
...
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting characters, ignoring numbers Barto9729 Excel Worksheet Functions 7 September 25th 13 07:08 PM
Sorting on only certain characters in a cell Lesa Excel Worksheet Functions 3 November 25th 08 07:32 PM
Ignoring characters when sorting amy153 Excel Discussion (Misc queries) 0 February 14th 06 09:20 PM
Number of characters in a cell (one row, merged columns) Dajana Excel Discussion (Misc queries) 1 September 19th 05 09:30 PM
Sorting by Number of Characters cny2 Excel Discussion (Misc queries) 3 July 28th 05 04:40 PM


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"