Merge cell contents into a text block?

Hi,

I need to merge the contents of an Excel 2007 workbook into a text document, creating a series of paragraphs that look like this:


Text text text [contents of cell A1] text text text [contents of cell A1] text.

Text text text [contents of cell A2] text text text [contents of cell A2] text.

Etc.


Apart from the cell contents, each paragraph will be identical. (I would do this by hand, but there are about 500 paragraphs.)

Is there a way to merge the cell contents like that into a text document (Word or whatever)? Thanks!

(P.S. I hope this was in the right forum area.)

Create a formula that catenates the necessary text, e.g.,

="Some text " & A1 & " some more text " & A1 & " the last of the text."

Then paste-link that into Word, or do a mail merge.