=LEFT(cellref,5)


Gord Dibben MS Excel MVP


On Sun, 28 Jan 2007 10:32:01 -0800, cdbinder
wrote:

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?