If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Sorting by surname when first name and surname are in the same cel
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.. |
#2
|
|||
|
|||
Sorting by surname when first name and surname are in the same cel
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" wrote: 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.. |
#3
|
|||
|
|||
Sorting by surname when first name and surname are in the same
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.. "Pokey" wrote: 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" wrote: 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.. |
Thread Tools | |
Display Modes | |
|
|