If I were to have a column containing the data of "A1, A2, ... A10, A11, B1, B2, ... B10, etc." where the letter will represent the first letter of the lighthouse name, and the number after it would be where I want it sorted in order by. Is there a way that I can have the sort to have A10 to appear after A9 and B10, after B9, etc. instead of appearing after A1 and B1? Does this make any sense?
|