[Ham-Computers] SORTING CALLSIGNS WITH EXCEL

[Lu]

These worked for me in Excel 2003:

Using his formula to output suffix including call-area number:

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

shorter version which also appears to work:

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

shorter version of his that outputs suffix without call-area number:

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

Using his ideas to output just call-area number:

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


73

Lu
N2SLN