Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting alphanumerically in a table
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks! That will do it. "Jezebel" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a table while keeping some related rows together | Tables | |||
Dragging table column resets | Tables | |||
Row height problem with table in table | Tables | |||
include all cells in sorting table | Tables | |||
table caption numbering | Tables |