[Ham-Computers] SORTING CALLSIGNS WITH EXCEL

[Ed - K9EW]

Hi Steve,

Well, you were right about Francis, the "Excel Addict".  I sent him an
email, and within a couple of hours he replied with this solution
(which works)...

Put this formula in an adjacent column and sort on this column.

=MID(A1,IF(ISNUMBER(VALUE(MID(A1,2,1))),2,IF(ISNUMBER(VALUE(MID(A1,3,1))),3,
0)),9)


Formula Explanation:

IF(ISNUMBER(VALUE(MID(A1,2,1))),2,
This part of the formula checks if the 2nd character is a number. If it is,
it returns 2 (to be used by the MID function).

IF(ISNUMBER(VALUE(MID(A1,3,1))),3,
This part of the formula checks if the 3nd character is a number. If it is,
it returns 3 (to be used by the MID function).

=MID(A1,value returned by ISNUMBER function,9)
The MID function returns 9 characters starting at the number returned by
ISNUMBER

Hope this is of some use to someone else sometime in the future.

73,
ed - k9ew