PDA

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



TheAncient
2013-08-13, 06: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 ?

millz
2013-08-14, 03: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

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

TheAncient
2013-08-14, 03: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.

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