Sure. You can split it. First column: =left(d2,5) Second column:
=right(d2,4).
*******************
~Anne Troy

www.OfficeArticles.com


"js42" wrote in message
...
I am working in a spreadsheet that has a column of zip codes in the zip +
4
format (00000-0000). All I need is the first 5 numbers of each zip. How do
I
convert it from the current format to just 5 digits, or can I split the
data
into 2 columns, one with the first 5 digits, and the other with the
additional 4?