Thread: sorting error
View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Your first example sorted properly for me, so I could not replicate.

Excel ignores dashes when sorting, so your second example is actually
properly sorted.

HTH,
Bernie
MS Excel MVP

"abstsogds" wrote in message
...
I get the following (2 examples) sorting errors in a straight-forward sort

on
a column.
Cannot find any error report on this?

Example 1 (doesn't handle V and W correctly?)

VAP2
WAP3
WAP4
WAP7
WAPRL
WAPZR
VASK

Example 2

V_V2
V-12
V12L_C
V23
V-34
V-38