Need help sorting a sheet

[kefalo]

Hi guys,

So before I shoot myself in the head I thought I'd ask for some help here, this community saved me hour if not days of work a number of times.

Here is the situation:

I have a sheet with two columns with over 10k rows. It's a list of locations and I only need to keep the ones that are in the USA.

The problem is that the rows alternate, a few USA then one France and so on and the text of the column has the address and some other data and the country in the same column so I can't just sort by country. It might not be clear but take a look at the example I am attaching and you'll understand.

example.xls

I just need the sheet sorted by country where the location is so that I can delete all non-US at once.

I hope I was clear enough.

[oeldere]

Since you have excel 2003 text to column won't work. They are not available in the version 2003.

Or do you have a newer version of excel.

It could also be done with a formula if the country is Always after the last , in the datacolumn.

[Fotis1991]

Since you have excel 2003 text to column won't work. They are not available in the version 2003.

.

https://www.youtube.com/watch?v=sJmczgZ_Myo

[oeldere]

@fortis1991

I realy thought excel 2003 don't have that functionality.

Kafelo, can you shine the light on this one; and report if it is available or not.

[kefalo]

yes, it does I feel so stupid when the solution is this simple but I just didn't know how to Google this...

I used delimited and used coma as a separator and it worked like a charm

Thanks a million

[oeldere]

@Kefalo

thanks for the reply.

also learned something today

[StuCram]

Another approach would be to use a formula in column C to extract the country from the end of the address and then sort by that column

….
Enter this formula in cell C2:
=MID(B2,LEN(B2)-3,3)

Then fill down as needed.

Hope this helps.
- Stu