Home » Category » Microsoft Excel

Microsoft Excel: ZIP CODES

205| Wed, 04 Jun 2008 15:04:00 GMT| anonymous| Comments (2)
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?

Keywords & Tags: zip, codes, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495097/
 
«« Prev - Next »» 2 helpful answers below.
Sure. You can split it. First column: =left(d2,5) Second column:
=right(d2,4).
*******************
~Anne Troy

www.OfficeArticles.com

"js42" <js42...discussions.microsoft.com> wrote in message
news:8C685D30-C211-4C12-8CFC-ABE191461974...microsoft.com...
> 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?

anne | Wed, 04 Jun 2008 15:06:00 GMT |

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?

dukecarey | Wed, 04 Jun 2008 15:07:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories