Hi,

I manage a magazine subscription list in Excel. The subscription number is
made up of 3 characters - the first being the first letter of the surname
and the second being the next unique number in the surname letter series, ex
Smith would be S1 and Sloan would be S2 and so forth. When these are sorted
subscription numberwise, Excel will sort S1, then S10 and then go on to S2,
S20 etc. Is there any way to make excel sort it as S1, S2, S3 and so on?

Thanks in advance,
Marzban