help sorting with commas

M

Myrna Larson

If you just sort normally, how does the result differ from what you want? I
notice that you want the item with 5 parts (an "e" term) to come before one
with only 4 parts. Normal sorting would put them the other way around.

If the result isn't what's wanted, then you'll have to separate the data into
separate columns (use Data/Text to Columns, Delimited, with Comma) and sort
the individual columns.
 
Top