View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MS-Exl-Learner MS-Exl-Learner is offline
external usenet poster
 
Posts: 132
Default 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