I am looking for a way to extract excel data into a word document, from the VBA in the word document. There is one cell in the excel file that is either empty or contains data that needs to be split so for example:
Excel Data
Cell1 Cell2 Cell3 Cell4
Yes Yes No...