|Thanks for reply. After posting question, I hit uponj an answer. I have roster of members of an amateur radio club listing some 100 members by their call signs|
in alpha order. Call signs can start with any one of 4 or 5 letters and consist of one numeral from 0 to 9 in any one of the first 3 positions, followed by 1 to 3 letters. I want to sort them alpha by the letters following the numeral. Thus the need to separate these letters. After many trials, the following does it:
=(IF(ISNUMBER(MID(A1,1,1)),MID(A1,2,4),IF(ISNUMBER(VALUE(MID(A1,2,1) ) ),MID(A1,3,4),IF(ISNUMBER(VALUE(MID(A1,3,1) ) ),MID(A1,4,4)," "))))
Thanks again for the help.