Hi Amalia > I want A1 - A100 to sort that way rather than A13, A14, A2. >
I'm not sure if I understand. But if you get A1 A12 A100 A2 A23 A3 that IS a "true alpha numeric sort" and that is what I get in this example If you need a sort in a "numeric" sense: A1 A2 A3 A12 A23 A100 You have to split the column, f.e. like this: =LEFT(A1;1) and =VALUE(MID(A1;2;LEN(A1))) Then you use the both new columns (menu: data/sort) for the sort -- _________________________________________________________________________ Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
