Sort by town name, which follows first name and initial; period; andcomma.

[Pierre]

Have a list of club members, and would like to sort this list by
locale or town name.
The text follows this sequence:
Rick J., Ocala, CA
Sue R., Elmwood Forest, CA
Charlie T., Sacramento, CA

Is there an effective way to sort alphabetically by town name?
The result would be Sue, followed by Rick, and then Charlie.
There are 300+ entries; manually reformatting would be possible, but
not very timely.

TIA for any ideas.
Pierre

 

[Mike H]

Hi,

I've assumed your data are in A1 down. Put his in b1 and drag down to the
length of column A

=TRIM(MID(A1,FIND(",",A1)+1,FIND(",",A1,FIND(",",A1)+1)-FIND(",",A1)))

Select both columns and sort on this helper column which you can hide if you
want.

Mike

 

[Shane Devenshire]

Hi,

Select your column of data and choose Data, Text to Columns, Delimited, and
click Next, choose Comma and click Next. Change the destination cell or
leave it the same and click Finish.

This will split your data into 3 columns which will allow you to sort
quickly and cleanly.

 

[Pierre]

Hi,

Select your column of data and choose Data, Text to Columns, Delimited, and
click Next, choose Comma and click Next.  Change the destination cell or
leave it the same and click Finish.

This will split your data into 3 columns which will allow you to sort
quickly and cleanly.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire







- Show quoted text -

Thank you Shane & Mike. They both did the deed.

Pierre