Sorting by number of characters
May be this...
=LEN(A1)
Change the A1 to your Item Number Cell.
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"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
|