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