"find and replace to replace each instance of a comma followed by a space (, ) with a page break (^n). Then it selects all and cuts it onto the clipboard" was bracketed. Not sure why you didn't see them?

You were correct about word being used to format the data for how I wanted it in excel.

Ironically, one of my coworkers just took a look at this and pointed out the obvious thing that I missed- I could have just used text to columns, copied the resulting row of data, and pasted by transposing the data so it would be in one column.

Is that what you were going to tell me?