Linking Excel Data to Word: Link to Excel function

[jamy]

I'm trying to copy content from Excel into a Word report and have it automatically update. The process I'm using:

1. in Excel, copy the cell with the desired data
2. switch to Word and paste
3. click the paste options icon that appears beside the pasted text, and select: "Match Destination Formatting and Link to Excel"

This works perfectly EXCEPT it inserts a newline before and after this text... which is annoying as I need this text to be a part of a paragraph and have ~100 separate links to make.

Things I've tried:
1. all the paste options in Word
2. in Excel, turn off wrap text

Any ideas on how to eliminate the extra newlines? Any help greatly appreciated.

Thank you.

Jamy