Thread: [Solved] Data Sorting Question
View Single Post
 
Old 01-29-2015, 12:05 PM
AQWst AQWst is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 3
AQWst is on a distinguished road
Default

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?
Reply With Quote