How do I convert 9 digit zipcodes to 5 digits?
 

I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format:
12345-6789

How can I convert these zip codes to a column that just has the first five
digits, that is:
12345

?

I will appreciate advice.

How do I convert 9 digit zipcodes to 5 digits?
 

In the new column use the formula =LEFT(A1,5)

"Robert Judge" wrote:

I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format:
12345-6789

How can I convert these zip codes to a column that just has the first five
digits, that is:
12345

?

I will appreciate advice.

How do I convert 9 digit zipcodes to 5 digits?
 

=left(a1,5) will pull the first 5 characters from a cell.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Robert Judge" wrote in message
...
I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format:
12345-6789

How can I convert these zip codes to a column that just has the first five
digits, that is:
12345

?

I will appreciate advice.

How do I convert 9 digit zipcodes to 5 digits?
 

DataText to Columns

De-limited by -

Choose to not import(skip) the second column.


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 08:17:09 -0800, Robert Judge
wrote:

I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format:
12345-6789

How can I convert these zip codes to a column that just has the first five
digits, that is:
12345

?

I will appreciate advice.