Hello,
I have a 50 page word file of a contract, that I need to track each item line by line by item during the project life time. To do that, I need to move it into Excel. Text is simply made up of contract item numbers and its definitions in a row.
I'd like copy the "item numbers" into one column and the "item definitions" right to next column in Excel.
How can I make an xls VBA macro to open the word file and copy the item numbers reading the symbol "©", and copy item definition by reading the "®" symbol that I will add both as a pseudo markers just before "item numbers" and "item definirions" in the original word file?
P.S © & ® symbols have no any use in the original contract text.
Regards,
I have a 50 page word file of a contract, that I need to track each item line by line by item during the project life time. To do that, I need to move it into Excel. Text is simply made up of contract item numbers and its definitions in a row.
I'd like copy the "item numbers" into one column and the "item definitions" right to next column in Excel.
How can I make an xls VBA macro to open the word file and copy the item numbers reading the symbol "©", and copy item definition by reading the "®" symbol that I will add both as a pseudo markers just before "item numbers" and "item definirions" in the original word file?
P.S © & ® symbols have no any use in the original contract text.
Regards,
