Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting numbers with text
Hello,
I need to sort two colums - one is a date - example 3/20/2008 04/5/2008 5/07/2008 and then another column of numbers - example 2007A2563 2007B3546 2007A2873 I really need the numbers after the letter to be in order. The first numbers just pertain to the year, the numbers after the letter are file numbers. Thanks for any help. -- Dena320 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting numbers with text
If the data is consistent as your example shows, I would break the column of
alpha numbers into two columns using datatext to columnsfixed width Sort by new number-only column. Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 10:38:00 -0700, dena320 wrote: Hello, I need to sort two colums - one is a date - example 3/20/2008 04/5/2008 5/07/2008 and then another column of numbers - example 2007A2563 2007B3546 2007A2873 I really need the numbers after the letter to be in order. The first numbers just pertain to the year, the numbers after the letter are file numbers. Thanks for any help. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting numbers with text
"dena320" wrote: Hello, I need to sort two colums - one is a date - example 3/20/2008 04/5/2008 5/07/2008 and then another column of numbers - example 2007A2563 2007B3546 2007A2873 I really need the numbers after the letter to be in order. The first numbers just pertain to the year, the numbers after the letter are file numbers. Thanks for any help. -- Dena320 If Gord's suggestion is not suitable you still need a helper column. Use this to separate the numbers and sord the data. =RIGHT(A1,LEN(A1)-4) It assumes that the first 4 number will always be the year. Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help sorting text as numbers | Excel Worksheet Functions | |||
Sorting (Numbers with Text) | Excel Discussion (Misc queries) | |||
Help with sorting numbers with text suffix | Excel Discussion (Misc queries) | |||
Sorting numbers as Text | New Users to Excel | |||
SORTING TEXT AND NUMBERS | Excel Worksheet Functions |