Extracting vital data from one cell that contains a jumble of data, in no particular order

i have cells that contain an entire address ie: company name, street address, postal/zip, country, state
and not always in that order

and sometimes there's even missing information, like country is missing

i am wanting to have new columns with CITY , STATE/PROV, COUNTRY, ZIP , AND STREET ADDRESS

Is there some way of doing this is am open to anything

macros, website refrences ie if i put in the zipcode it refrences a site and spits the state country and such in the correct columns

if statements even, i doubt you can do it with if statements though


SEE ATTACHED EXAMPLE PLEASE !!

hell if you can even recommend an ad-on to put in excel im open to that, actually that would be easiest

and i really need to saave the time i have 100's of hours of work otherwise


thanks for your time i know its valuable !!

nc