1. Create a formula (replace {SOLICITORNAME.EN_US} with the actual Solicitor Name field from your field explorer):

Mid({SOLICITORNAME.EN_US}, Length({SOLICITORNAME.EN_US})-InStr(StrReverse({SOLICITORNAME.EN_US}), " ") +1)

2. Insert a group (which automatically sorts the field being grouped) on the above formula.