On Wed, 2003-07-02 at 10:55, Paul wrote:
Sorry if this comes up every other week... I'm trying to sort part designations for electronic components. What I get is something like this: D1 D10 D11 D12 D13 D2 D3 D4 Any ideas on how I could make Gnumeric sort in a more natural order, such as D1, D2, D3?
Assuming that your codes are really that nice, you could create another column with formulas like: =value(right(Sheet1!A1,len(Sheet1!A1)-1)) (assuming the original codes are in column A and then sort by that calculated column. It is tougher if you alphabetc prefix varies in length. Andreas
Attachment:
signature.asc
Description: This is a digitally signed message part