sort??

[Kitty]

Hello, Everybody.
I have serial numbers such a
H5805
H5805Q
H5806
H5806Q
H5807
H5807Q
H5808
H5808Q

I want excel to sort them just like how I listed it above.
but excel keeps pushing all the serial numbers with the Q to the
bottom.
Is there a way for excel to sort and omit the prefix Q?
Please let me know.
Kitty

 

[AlfD]

Hi!

??

My Excel2003 sorts them just like you have listed them.

Al

 

[Myrna Larson]

So does Excel 2002.