Prev: Counting Colored Cells that are Conditional Formated
Next: HELP! Split cell contents to new rows
From: NicoleS on 13 May 2010 12:51
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
From: Ms-Exl-Learner on 13 May 2010 12:56
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
From: Pete_UK on 13 May 2010 12:59
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 <Nico...(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Counting Colored Cells that are Conditional Formated
Next: HELP! Split cell contents to new rows