Macro for USA address?

[calvinle]

Hi,

I have a file with a long listing of addressses, but I need to split the address to column A as STATE ZIP COUNTRY, and column B to City.
Is there a way to run a macro to split the first character until space to the next column? Or to go back from USA ZIP then STATE as 12 character the split?

Here is the sample file..

City.xlsx

Please help..

Thanks.

[JOHN H. DAVIS]

This may help some:

Please Login or Register  to view this content.

Only handles USA though.

[calvinle]

Thank you very much. It appears a little errors on addresses that are not conform to this macro, but i fix it fine.
Thanks.

[JOHN H. DAVIS]

You're welcome. Glad to help out.