Sorting by number of characters

  • Thread starter Thread starter NicoleS
  • Start date Start date
N

NicoleS

I am using Excel 2007
(thought I posted this earlier, but can't find it - even with google group
search).

I need to sort an inventory list according to the number of characters in
the item number (not by numerals).

Is this possible?

Thanks!
Nicole
 
May be this...

=LEN(A1)

Change the A1 to your Item Number Cell.

Remember to Click Yes, if this post helps!
 
In a spare column you can put this on row 2:

=LEN(A2)

and copy down. Include this column within the sort area, and sort on
this new column.

Hope this helps.

Pete
 
Back
Top