AbnRanger
05-01-2005, 10:30 PM
This is my first try at using this site, so thanks to all and my aplogies if I don't get this posted properly.
I'm sure there is a simple solution to my problem, but my VBA skills are poor.
I have quite a bit of data in Excel that includes US zip codes in one column. Most of these zip codes are in the 5+4 format (#####-####). Some is in the 5 digit format only. Some is incorrect. Some is a foreign zip code equivalent.
What I need is to convert the 5+4 zip codes into the 5 digit format, while leave the 5 digit, errors, and foreign codes alone.
Reformatting the column using the zip code format available seems to have no effect, so it seems to me I need a macro. On the other hand, if there is a way to force the format to work, that might be the simplest approach.
Thanks for your help!
I'm sure there is a simple solution to my problem, but my VBA skills are poor.
I have quite a bit of data in Excel that includes US zip codes in one column. Most of these zip codes are in the 5+4 format (#####-####). Some is in the 5 digit format only. Some is incorrect. Some is a foreign zip code equivalent.
What I need is to convert the 5+4 zip codes into the 5 digit format, while leave the 5 digit, errors, and foreign codes alone.
Reformatting the column using the zip code format available seems to have no effect, so it seems to me I need a macro. On the other hand, if there is a way to force the format to work, that might be the simplest approach.
Thanks for your help!