Excel Postal Code Macro or Solution
Budget: $10 – $30 USD
We have a big excel mailing list.
Columns for name, address, address 2, city, state, zip (postal), country, etc.
My issue is this: right now we are spending too much time formatting the postal code cells by country. Different settings for all these countries for formats.
Would be interested in a solution for this to automate it a bit more, perhaps checking the countries and then auto-formatting the postal code to necessary parameters, or something similar.
We are not XLS experts so this must be easy to use and work in a Windows enviroment.
Columns for name, address, address 2, city, state, zip (postal), country, etc.
My issue is this: right now we are spending too much time formatting the postal code cells by country. Different settings for all these countries for formats.
Would be interested in a solution for this to automate it a bit more, perhaps checking the countries and then auto-formatting the postal code to necessary parameters, or something similar.
We are not XLS experts so this must be easy to use and work in a Windows enviroment.