A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 05:05 PM posted to microsoft.public.excel.newusers
Louise
external usenet poster
 
Posts: 358
Default 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  
Old May 12th, 2010, 06:38 PM posted to microsoft.public.excel.newusers
pokey
external usenet poster
 
Posts: 14
Default 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  
Old May 19th, 2010, 12:36 PM posted to microsoft.public.excel.newusers
Louise
external usenet poster
 
Posts: 358
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.