I have an issue where I needed to perform a "text to rows" function rather than a "text to columns" funcion. I figured out how to do this by copying the data that needed split up into word and doing a find & replace that replaced ", " with a page break "^n". Then I cut all the seperated information and when I paste it into excel I get the seperate pieces of information in seperate cells in the same column.



I used a macro in word connected to a button to do all this with one click, as I need to do it repetatively with different lists of ingredients. I'm wondering if there is some way to embed the word document and/or its macro into excel so that I'm not clicking back and forth between windows and having to open multiple different programs and windows.

Any advice would be greatly appreciated! Let me know if I can be more clear on what I'm trying to do.