| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can I get the zip codes to addresses
I have a mess of addresses, but no zip codes. I use ms excel and a whole
column of zip codes to fill. Any advice, si vous ple? |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How can I get the zip codes to addresses
Hi Ricardo,
Since this is an Excel question, you should post your query in an Excel newsgroup (eg microsoft.public.excel.worksheet.functions). Assuming your data table has a column of suburb/locality names and a column of State names/codes, matching these to a table of zip codes and State names/codes can by done via a lookup function. -- Cheers macropod [MVP - Microsoft Word] "Ricardo Antonio" Ricardo wrote in message ... I have a mess of addresses, but no zip codes. I use ms excel and a whole column of zip codes to fill. Any advice, si vous ple? |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How can I get the zip codes to addresses
Contact the Post Office & obtain a Zip Code Directory. You may be able to
Google one on line but I'm not sure how accurate it might be. Good Luck |:) Bob Jones [MVP] Office:Mac On 2/22/09 3:34 PM, in article , "Ricardo Antonio" Ricardo wrote: I have a mess of addresses, but no zip codes. I use ms excel and a whole column of zip codes to fill. Any advice, si vous ple? |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How can I get the zip codes to addresses
See http://zip4.usps.com/zip4/welcome.jsp
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Ricardo Antonio" Ricardo wrote in message ... I have a mess of addresses, but no zip codes. I use ms excel and a whole column of zip codes to fill. Any advice, si vous ple? |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How can I get the zip codes to addresses
There is a search facility at http://zip4.usps.com/zip4/welcome.jsp.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "CyberTaz" wrote in message .. . Contact the Post Office & obtain a Zip Code Directory. You may be able to Google one on line but I'm not sure how accurate it might be. Good Luck |:) Bob Jones [MVP] Office:Mac On 2/22/09 3:34 PM, in article , "Ricardo Antonio" Ricardo wrote: I have a mess of addresses, but no zip codes. I use ms excel and a whole column of zip codes to fill. Any advice, si vous ple? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please give us REVEAL CODES like WORD PERFECT not reveal codes in. | Microsoft Word Help | |||
| Addresses | New Users | |||
| Hyperlinks -Relative Addresses and Absolute Addresses | Microsoft Word Help | |||
| I can't see anything but codes or field codes...help!!!! | Microsoft Word Help | |||
| I can't see anything but codes or field codes...help!!!! | Microsoft Word Help | |||
Linear Mode
