Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.programming
|
|||
|
|||
Word to Excel conversion of addresses
I have a document in word thats got address info in it. The format is
generally: Storenumber address1 city, state,zip opendate accountnumber expirationdate phone fax contact name some have 9 lines, some 10-12 or 13 lines per each. They all though have roughly the same format, where info exists. Address line 2 for example is optional. Some have the Storenumber then the next line is followed by the shopping center name, then the address, then city, state & zip info. What I need to do is to convert the document into an excel sheet, with each column in Excel corresponding to a row like they are in the word document. Problem is, the info's always in the same order, it's just that optional rows of info are not always in there holding a place. Is there a way to get this into Excel? BC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Excel to Word | Excel Discussion (Misc queries) | |||
Conversion of a word doc to excel | Excel Worksheet Functions | |||
Word to Excel format conversion? | Excel Discussion (Misc queries) | |||
copy addresses from word to excel | Excel Worksheet Functions | |||
Excel conversion to word 2000 Text | Excel Programming |