How to normal very messy Address data

Im trying to put together a customer geographic demographics report, but unfortunately my database is a bit messy. Built one out with ZIP data, but only about 20% of our customers have the ZIP code in the actual zip field.

About 60% of our customers have an address line that included either a normal street address, street plus city plus state plus maybe ZIP. Sometimes theres a comma in between st and city sometimes not, sometimes the city is all caps sometimes not, etc. Etc.

Are there anyways I can go about normalizing the data so I can work with it that isnt going to take forever? Im pretty rusty with excel in general so even small tips would be useful.