Hello all,
We have over 3000 pages in a word document that are letters of this format.
Reference No:BANGA06254J1/JAN/2013 Date:31-JAN-2013
MATHEW JOHNSON
C.B.192,SECTOR-5
SALT LAKE CITY .
BANGALORE 560 064.
Dear Sir/Madam,
Payment of Pension for the month of JAN/2013.
We advise that an amount of Rs.***9365.00
......the rest of the letter follows.
What we need to get into excel is the name and address(in a single cell together as in the letter itself) in the next available row and then repeat it till the end of the document.
Thanks a lot.