| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort a list with Mr, Mrs, Miss ?
Hi
I have a list of names in a spreadsheet that includes Titles, Names & addresses Name Address Town Postcode Mr A Burns 24 Hill street town postcode Mrs B Mitchel 45 Acreback road town postcode Miss G Hay The sheddings town postcode etc etc etc etc How do I sort this list by surname? It keeps sorting by Miss, Mr, Mrs -- Martin ©¿©¬ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill to Last Row but Miss Some Rows? | Excel Discussion (Misc queries) | |||
| Excel User Conference - Don't miss out! | Excel Discussion (Misc queries) | |||
| Excel User Conference - Don't miss out! | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Miss-wrote previous "IF" problem | Excel Worksheet Functions | |||
Threaded Mode
