•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#rows.com
#no-code spreadsheet solutions
#address normalization
#customer demographics
#ZIP code
#messy data