Sorting by number of characters
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
On May 13, 5:51*pm, NicoleS wrote:
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
|