grouping accounts

[cdulong]

I am exporting a list of accounts with balances into an excel spreadsheet and I am having an issue with sorting/grouping the accounts.

What is currently is happening is when I open the file all the acounts are in numerical order (which is normal for excel) and are list as such

4101-002
4101-003
4101-004
4505-002
4505-003
4505-004

What I need is to group them based on the last three digits and then sort those groups based on the first four digits to give me the following results:

4101-002
4505-002
4101-003
4505-003
4101-004
4505-004

Any help would be greatly appricated.

Thanks,
cdulong

 

[Andrzejek]

When you "exporting" your data into Excel, can you split it at "-"?
[tt]
ColA ColB
4101 002
4101 003
4101 004
4505 002
4505 003
4505 004
[/tt]
The rest is easy....

Have fun.

---- Andy

 

[cdulong]

Thats were it gets tricky. The software does not allow me to spilt the number into two columns.

 

[SkipVought]

IN Excel, you can use Data > Text to columns... to PARSE your column into TWO columns, using the - as a DELIMITER.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}