Problem in Excel

[spotit3]

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.

[VHG]

There is but I am not sure what it is.

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.

[Vagrant]

Select the names, choose Data -> Text to Columns

[spotit3]

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!

[spotit3]

Apologies, vagrant, I misread your reply. Text to data has sorted it. many, many thanks!