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