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

Word to Excel conversion of addresses
 

Hi Blasting Cap,

From what I can see, whether its practical to do this with a macro largely depends on whether the data are all contained within the
one paragraph or table and whether there's any extraneous text in that paragraph/table. Alternatively, the the data on each line are
prefixed with an indentifying string, that would make it easy.

--
Cheers
macropod
[MVP - Microsoft Word]


"Blasting Cap" wrote in message ...
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