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

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?

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

In a separate column

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

Copy the new column, EditPasteSpecialValues and then delete the original
column.

--
---
HTH

Bob


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



"RI Foodie" <RI wrote in message
...
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?

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

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

"RI Foodie" <RI wrote in message
...
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?

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

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.

--
Cheers,
Michelle
"Anyone who says he can see through women is missing a lot." Groucho Marx


"RI Foodie" wrote:

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?

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

If the zip codes are in this format:

12345+1234

Select the range of interest
Goto the menu EditReplace
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.


--
Biff
Microsoft Excel MVP


"RI Foodie" <RI wrote in message
...
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?