How to sort the name in Excel

[Sanju Baba]

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. Any help massively appreciated.

[JyotiT]

According to my information 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. May this will help you out.