sorting alphanumerically in a table

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

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
 
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.
 
Thanks!

That will do it.

Jezebel said:
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.
Click to expand...
 
Back
Top