I have a list of names in an Excel sheet e.g. Mr & Mrs Tom Smith. Is there any way I can move the titles to a separate column to allow me to dput them in alphabetical order? I think I have done it before but it is so long ago I can't remeber which funcion I used. Any help would be greatly appreciated.
But as general "database" rule you should always have the title (Mr Mrs Dr etc) in one column, the first name in a second column, and the surname in a third column.
Then you can easily sort by surname.
As you have seen, having the Mr or Mrs in the same column as the first name and surname does not help when sorting.
Unfortunately I didn't input the database. It is the only way it will come out of the program I am using. I can't select the names as they are in the same column as the titles unless i go through each row individually and there are over 500!