View Full Version : Avoid paragraph marks when linking Word document to Excel spreadsheet

2013-08-13, 05:29 PM
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 ?

2013-08-14, 02:48 AM
Hi, I don't use Word much so may not have a very good solution to fix your problem, but one thing you can try as a workaround, is:

E.g. in Cell A1 you have "153"
Put this formula in Cell A2 : ="This order is for "&A1&" guests."
then link your Word document to cell A2 instead

2013-08-14, 11:18 AM
well you can go to the left end of your 153 click and press a backspace and you are done

2013-08-14, 02:36 PM
I did find the solution myself:
1. Copy the cell in Excel
2. In Word select PASTE SPECIAL - then select UNFORMATTED TEXT
3. Manually apply your formatting

millz: Thanks! Your solution would work as well.
spiffy: Thanks for trying to help. It would be even better if you tried your "solution" before posting it. If you had, you would have found out that your "solution" doesn't work.

2014-01-17, 06:51 AM
ya good one ......