|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2010, 05:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by number of characters
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 
|
|
#2
May 13th, 2010, 05:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
May 13th, 2010, 05:59 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
