traffictrader
New Member
- Joined
- Oct 3, 2014
- Messages
- 2
Hi Everyone,
This is my first post here on the forum.
As a novice user of Excel, it is so great this forum exists.
Thanks in advance for any help.
I have a large spreadsheet of US zip codes that needs to be cleaned up.
Question #1:
Some are in the 5 digit format (which I need) Eg: 90210 and some are in the 4 digit format eg: 4536
Is there a way to add a zero in front of all the 4 digit format zip codes using the Find and Replace function? Or is there some other way to do this?
Question #2:
The US Post Office sometimes places a 4 digit extra code after the standard 5 digit code Eg: 90210-9876
Is there a way to easily delete all the 4 digit extra codes and just keep the standard 5 digit codes?
Thanks again for any help on this.
Cheers,
Ralf
This is my first post here on the forum.
As a novice user of Excel, it is so great this forum exists.
Thanks in advance for any help.
I have a large spreadsheet of US zip codes that needs to be cleaned up.
Question #1:
Some are in the 5 digit format (which I need) Eg: 90210 and some are in the 4 digit format eg: 4536
Is there a way to add a zero in front of all the 4 digit format zip codes using the Find and Replace function? Or is there some other way to do this?
Question #2:
The US Post Office sometimes places a 4 digit extra code after the standard 5 digit code Eg: 90210-9876
Is there a way to easily delete all the 4 digit extra codes and just keep the standard 5 digit codes?
Thanks again for any help on this.
Cheers,
Ralf