 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008How 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? In a separate column =LEFT(A1,LEN(A1)-5) Copy the new column, Edit>PasteSpecial>Values and then delete the original column.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >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? 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 >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? 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. SignatureCheers, Michelle "Anyone who says he can see through women is missing a lot." Groucho Marx > 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? 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. SignatureBiff Microsoft Excel MVP >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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.