View Single Post
  #2   Report Post  
Jezebel
 
Posts: n/a
Default

The problem is that those strings are not numbers, so there's no direct way
to sort them as such. You need to split the sort value into the text prefex
and numeric suffix, and sort on those separately. Probably quickest to copy
the table to Excel and do it there -- add two columns to the right, the
first containing =Left(Ax,3) and the second containing =Mid(Ax,4,Len(Ax)-3).
Sort on your two new columns, then delete the added columns and paste the
lot back into Word.


"Fred" wrote in message
...
What sorting you see:
A1C1
A1C10
A1C11
A1C2

But A1C 'TWO' really comes after A1C1.

Soes anyone know how to make it work properly?
Thanks,
Forrest