Hi all

I've got a listbox that is already sorted as below.

1234 Williams Mr
1121 Henderson Mrs
0983 Harris J
0765 Thomas

I now want the list box or another to show the following.

1. Williams Mr 1234
2. Henderson Mrs 1121
3. Harris J 0983
4. Thomas 0765

Thanks
Rob