How do I delete the +four didgets from a Zip Code Column?

[RI Foodie]

I downloaded from a data base that has the Zip Code +4 (00000+0000) in a
single field. I have hundreds of line in this worksheet. How do I remove the
+0000 values inside all of the cells in the column?

 

[Bob Phillips]

In a separate column

=LEFT(A1,LEN(A1)-5)

Copy the new column, Edit>PasteSpecial>Values and then delete the original
column.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tyro]

If you have the zips in a1:a500 and all of the zips have 5 leading
characters before +, then in B1 put: =LEFT(A1,5) and drag down to b500

Tyro

 

[Michelle]

You can use the left function, and since the zip code is always a 5 digit you
can just put...
=LEFT(A1,5)
(Assuming that the zip code you want to extract is in cell A1.) Drag the
formula down as appropriate. Hope this heps.

 

[T. Valko]

If the zip codes are in this format:

12345+1234

Select the range of interest
Goto the menu Edit>Replace
Find what: +*
Replace with: nothing, leave this blank
Replace All

One caveat about this method. If any zip codes start with leading 0s they'll
be stripped off.