Sorting numbers with text

[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.

 

[Gord Dibben]

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

 

[Billy Liddel]

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