Macro Help: Word doc into Excel

M

MDMeyers

I need assistance with Importing Word doc into Excel, with:
1. Input data in this format:
[T-XXX} ADVERTISEMENT OF TAX SALE [XX-XXX-XX] ALL THAT TRACT OR
PARCEL OF LAND LYING AND BEING IN THE [XX]TH DISTRICT, [SECTION],
[COUNTY], [STATE], LYING WITHIN LAND LOT [XXX], IDENTIFIED AS TAX
PARCEL [XX] ON THE FIELD MAP OF THE [COUNTY] TAX ASSESSOR, AND BEING
MORE PARTICULARLY DESCRIBED AS FOLLOWS: AFORESAID PROPERTY BEING
FURTHER IDENTIFIED AS LOT [XX], UNIT [X], OF THE RESERVE FKA
[SUBDIVSION], AS SHOWN ON SURVEY RECORDS IN PLAT BOOK [XXX], PAGE [XX],
COUNTY, STATE, RECORDS. SAID PROPERTY APPEARING TO BE RESIDENTIAL
PROPERTY HAVING AN ADDRESS OF [ADDESS], [CITY], [STATE], ACCORDING TO
COBB COUNTY TAX RECORDS. Subject to restrictions on record in the clerk
of Superior Court, [COUNTY], [STATE]. As much thereof will be seized
and sold as will satisfy a State and County tax FIFA for the year(s)
2005, and for the amount of [$X,XXX.XX] plus other costs, levied on as
the property of [NAME] as record owner. Said defendant having been
served a notice of execution of tax levy this [DATE] .

Needs:
1. Remove garbage. :) Would like to replace "Standardized Text",
example Remove "ADVERTISEMENT OF TAX SALE.
2. Items in Bracklets [ ] are items I need to import to Excel. Values
will change, but structure alway same.
3. Any Item with errors saved for editting.
4. On import, check for deplicates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top