I am using Excel 97, I have a list of names in column A of
a worksheet like the following

Julie Smith (Accounting)
Albert George (Supplies)
Fred Merrydale (Finance)

I want to be able to sort them in alphabetical order with
their surname in ascending order.

To be even greedier it would be ideal if I could also sort
them into departmental order.

Can anyone please assist me with some code which could do
these options for me?

Thanks


Mark