Is it possible to sort a list of names after a full stop using Excel 2007.
e.g Mr A.Somebody I would like to sort the list of names using the surname,without having to place the surname in a different column, hope this makes sense!.
Warning, do NOT have any blank columns or hidden columns or it gets messed up. I speak from experience with mailing list last Dec - on that list they've now all got the wrong phone numbers :( I had to start again with a backup copy.
When I select all of the Names in column "B" then "Sort and Filter A-Z" nothing happened as stated in my last posting.If I select the first name only in column "B"then "Sort and Filter A-Z" they change to alphabetical order,not only do they change in column "B" but the contents of column "A" change as well. Which is what I needed. Does this sound correct?. I thought I would need to select all the names that I needed to change to alphabetical order.