Sorting numbers with text

  • Thread starter Thread starter dena320
  • Start date Start date
D

dena320

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.
 
If the data is consistent as your example shows, I would break the column of
alpha numbers into two columns using data>text to columns>fixed width

Sort by new number-only column.


Gord Dibben MS Excel MVP
 
dena320 said:
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.
Click to expand...

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
 
Back
Top