I am trying to merge addresses into a mail program that won't accept 9-digit
ZIP codes - some of the addresses in my worksheet are the acceptable 5-digit
ZIPs, some are the unaccepted 9-digit ZIPs. How do I efficiently trim or
shorten the cells that now have 9-digits, without manually going to each cell
and deleting the last 4 digits?