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!.
You can do it by using another column and by inserting a formula in that column and then sorting on it. The snag that you have is a variable surname length and you need to cater for mr and mrs and make sure that the dot always follows just the first initial.
With the first name in cell A1 then you can insert in a new column =MID(A1,FIND(".",A1)+1,12). This will return the surname in the new column up to a maximum of 12 letters in the surname which you can then sort on. If you have more than 12 letters then set the 12 to 25 or whatever.
I usually have a separate columns for titles, initials and surnames.
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.