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
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
