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
|