How extract City and State from list where not all addresses are in same format (excel 07)

Hello,

I have a rather large data set of addresses from around the world. This has made it difficult to extract the city, state, and country information as now all addresses are in the same format. Would anyone happen to know a way to extract the information I need. Eventually I'm trying to sort the data so I can create a histogram of where most of the users are located. I'm using Excel '07 btw.

Trader Vic's, Al Mussalla Road, Al Murar, Sharjah, 41974, United Arab Emirates
Trader Vic's, Al Mussalla Road, Al Murar, Sharjah, 41974, United Arab Emirates
Home centre, Wadi Mushaireb Street, Fereej Abdul Aziz (14), Doha, Qatar
Home centre, Wadi Mushaireb Street, Fereej Abdul Aziz (14), Doha, Qatar
Homestead, Miami-Dade County, Florida, United States of America
Al Luqta, Old Al Rayyan (52), Al-Rayyan, Ar Rayyan, Qatar
Dukhan Road, Al-Rayyan, Qatar
Dukhan Road, Al-Rayyan, Qatar
Al Zahra Street, Sharjah Industrial Area 4, Sharjah, United Arab Emirates
Sheikh Maktoom bin Rashid Al Maktoom Street, Muwayhat, Ajman, United Arab Emirates
Southwest 312th Street, Homestead, Miami-Dade County, Florida, 33033, United States of America
Southwest 261st Street, South Allapattah, Miami-Dade County, Florida, 33039, United States of America

Thanks for the response. The problem is not all of the addresses have the street name or some have the county information included. So I can't do text-to-columns because the information will not end up in the same column. To give you an example

1. 123 ABC St, Pittsburgh, PA
2. 123 ABC St, Pittsburgh, Allegheny County, PA

If I put this in the text-to-columns the problem would be that PA would end up in different columns. I need a way to extract the city and state information from close to 20,000 addresses.

Well city and state are easy to gather. Just not sure how to extract that information. It would be cool if I could search to see the frequency New York City for instance came up in my data set but the problem is there are some streets named New York City.