ExcelBanter - Sort by help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort by help (https://www.excelbanter.com/excel-discussion-misc-queries/253258-sort-help.html)

Martin ©¿©¬ @nohere.net

Sort by help

Hi
I have a list of namesin a spreadsheet
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
Etc
Etc

How do I sort this list by surname?
Using 2007
--
Martin
©¿©¬

David Biddulph[_2_]

Sort by help

See your previous message.
--
David Biddulph

Martin ©¿©¬ @nohere.net wrote:
Hi
I have a list of namesin a spreadsheet
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
Etc
Etc

How do I sort this list by surname?
Using 2007

All times are GMT +1. The time now is 03:55 PM.