ZIP CODES
 

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?

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?

First, make sure the column to the right of the Zips is empty
Next, use the Data menu - Text to Columns and select delimited and indicate
the delimiter is a hyphen
Excel will split them for you

"js42" wrote:

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?