Sorting by surname when first name and surname are in the same cel

[Louise]

I have both first name and surname in one cell, ie. Mary Byrne and want to
sort my list of names by surname first. Is it possible to divide the cells
into two or is it possible to sort by surname when both names are in the
cell..

 

[Pokey]

You need to separate the name and surname to sort. First highlight the column
and go to Data at the top, Text to Columns, choose Delimited with, the choose
tab and choose space, then next and finish.

 

[Louise]

Hi there,

Thank you so much.. you have made my life so much easier.. I have been
working with a list of over 600 people and not being able to sort them
alphabetically by surname was just a nightmare.. once again.. thank you for
your answer.. my list is all sorted and looking good!!

Best wishes
Louise..