Hi there,
I am stuck trying to link individual numbers in an Excel 2013 spreadsheet to text in a Word document.
Assume the spreadsheet has a cell that contains a number: "153"
This should be linked into a Word document such that it appears in a sentence e.g. "This order is for 153 guests".
The problem is, if I paste/link that number from the Excel spreadsheet, it inserts the number PLUS paragraph marks into my Word document. This means the Text is no longer on a single line but instead spans 3 lines ("This order is for" -next paragraph- "153" -next paragraph- "guests.")
Is there a way to make it appear in a single line ?