If the codes are of the form 12345-6789 say in A1, then

=left(A1,5) will return the first 5 and
=right(A1,4) will return the last 4
--
Gary''s Student


"ExcelExtrator" wrote:

I have field with 9 digit zip codes (5 digit plus 4 digits). I want to
create two separate fields from this one field - one field with 5 digits and
the othe field with 4 digits.

Thanks