Results 1 to 5 of 5

Thread: Avoid paragraph marks when linking Word document to Excel spreadsheet

  1. #1

    Avoid paragraph marks when linking Word document to Excel spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 ?

  2. #2
    Acolyte millz's Avatar
    Join Date
    Aug 2013
    Location
    Singapore
    Posts
    32
    Articles
    0
    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

  3. #3
    well you can go to the left end of your 153 click and press a backspace and you are done

  4. #4
    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.

  5. #5
    ya good one ......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •