Hi all

I have a column of names generated by my accounting program (Quickbooks), but the way Quickbook works means the names are sorted on their first entry which is usually the given name. Sometimes the names are husband and wife, and sometimes they may have two words making up their surname. Complicated!

I want to sort by surname - how could I do that?

e.g.

Jacqui Knight
Tom & Jerry Cat
Leonard da Vinci


Jacqui