Thread: Data sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk jk is offline
external usenet poster
 
Posts: 109
Default Data sort

How do I sort data in accending order when the data has text first and then
numbers seperated by a dash such as; boy-1, boy-2, boy-3.....boy-10? If I
use datasortaccendingok, it puts it in order like; boy-1, boy-10, boy-2,
boy-3. Is there a way to make it sort so it does not put boy-10 after boy-1
and instead puts it after boy-9 like I want?