What happens if you just take the leftmost 5? =LEFT(A1,5)


"krissmith7" wrote in message
...
Hi,
I have a column of zip codes. Some zips have just the first five digits,
some have the first five plus a hyphen and four more digits. I only want
the
first five. Now when I used that first formula....

=LEFT(A1,LEN(A1) - 5)

...it worked great for the zips with too many numbers on the end, but it
didn't duplicate the ones that only had five, it just left it blank. How
do
I get it to duplicate the first five AND delete the ones with too many
digits, so I'll be able to just delete the old column.

Thanks,
Kristin