=LEFT(A1,5) & "-" & RIGHT(A1,4)

so if A1 contained 085401234 the formula gives you 08540-1234
--
Gary''s Student - gsnu200860


"William" wrote:

I have a column with nine-digit zip codes, but there is no hyphen separating
the final zip four numbers. I need to use this column in a mail merge, but
don't want to go in and manually add all the hypens. There must be a way to
do this (Find/Replace using placeholders?) but I can't quite come up with it.
Ideas?

Thanks,
--
William