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

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.

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