ZIP CODES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top