Consider retrieving the Surname into col. B with the proposed formula and
then sort, col. A+B, as per col. B
You can hide col. B whenever you feel like it.
http://img251.imageshack.us/img251/4248/nonamef.png
Micky


"Martin ©¿©¬ @nohere.net" wrote:

Hi
I have a spreadsheet with a list of names
Mr & Mrs E. McAllister
Mrs E. Hay
Rev. G. & Mr M. Farquhar
Mrs M. Russell
Mr & Mrs J. Cuthbert
Mr R. Cuthbert
Miss Judith Cuthbert
Mr & Mrs M. Weller
Mrs C. Doherty
Mr & Mrs J. Stewart
Mr W. Ridges
Mrs M. Bell
Mr & Mrs D. Bell
Mr & Mrs J. McMurran
Mrs A. Erskine
etc
etc

How do I sort by surname please?
Using 2007
--
Martin
©¿©¬
.