View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcolson mcolson is offline
external usenet poster
 
Posts: 12
Default Sort to include hyphen

I'm having a problem with sorting my Data. When Excel does a sort, it
does not include hyphens. So MV-2 would come after MV1. But later,
when I try to import new data, I am doing a binary search. In this
search, MV-2, would be seen as less than MV1, because a '-' is less
than 1. Is there any way to do a quick sort that includes the '-' in
the search criteria?

Thanks,

Matt