Martin:-

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 35 towards the top of my home page.

Your data really needs to be reorganized as it is not really in a manageable
form.

However, for the Workbook I have uploaded, if you click in the drop down in
cell H 1 and select Sort A to Z you will get the people in the alpha order of
surname.

There are many ways this could be done.

If my comments have helped please hit Yes.

Thanks.


"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
©¿©¬
.