Hi

Can anyone help me with a formula for Excel 2007 to separate the colum
in to multiple colum ?
below the examples and i need to column to separate the column
Address, City, Stae, Zip code

Eg:

711 B East 10th Street Anniston AL 36207
785 N. Dean Road Suite 600 Auburn AL 36830
401 Tuscaloosa Avenue, Southwest Suite 210 Birmingham AL 35211
1830 14th Ave. South Birmingham AL 35205
1930 Edwards Lake Road Birmingham AL 35235
4515 Southlake Parkway Suite 150 Birmingham AL 35244
2224 Cahaba Valley Drive Suite A-1 Birmingham AL 35242

This would be near impossible to do 100% of the time.

Getting the zip code and the state is easy. The problem comes when the city
has 2 (or more) words in its name. For example, New York.

You can start from the right and work to the left looking for each next
space but city names with 2 or more words won't work using that logic.

--
Biff
Microsoft Excel MVP


"Raj Kumar" wrote in message
...
Hi

Can anyone help me with a formula for Excel 2007 to separate the colum
in to multiple colum ?
below the examples and i need to column to separate the column
Address, City, Stae, Zip code

Eg:

711 B East 10th Street Anniston AL 36207
785 N. Dean Road Suite 600 Auburn AL 36830
401 Tuscaloosa Avenue, Southwest Suite 210 Birmingham AL 35211
1830 14th Ave. South Birmingham AL 35205
1930 Edwards Lake Road Birmingham AL 35235
4515 Southlake Parkway Suite 150 Birmingham AL 35244
2224 Cahaba Valley Drive Suite A-1 Birmingham AL 35242