4+ Zip Code Conversion

[Guest]

My Excel Document contains a Zip Code column which contains a nine digit zip
entry (4,000 of them!) ALL without hyphens.

I need to figure out a way to add hyphens to these entries (in the proper
place) or just delete the last four+ digits of the the zip code in order to
achieve a mail merge.

I'm totally a novice and unfamiliar with macros. Is there an easy way to do
this without having to change each cell manually?

I appreciate any help.

PH

 

[Guest]

Are they all nine digit numbers?! If so you might be able to type this into
an empty column =LEFT(E13,5) & "-" & RIGHT(E13,4) and then use the fill
handle to drag the formula down to account for all 4,000 zipcodes. If you
want to place these new zipcodes over the originals highlight them all. Copy
the selection. The rightclick > Paste Special. Select the Values Radio
button and OK. That should fix everything. If they are a mix of nine digit
and five digit then it wont work. Be sure to change the cell location E15 to
the right column and row. Hopefully that helps.