View original (French)

Unwanted line break when copying/pasting from Word to Excel

AD922017 Posted messages 3 Status Member -  
m@rina Posted messages 27916 Registration date   Status Moderator Last intervention   -
Hello,

I can't seem to find the solution to the following problem:

When I copy a cell in Excel (2013) to paste it with a link into Word (2013), I consistently get a line break that appears in my Word document.... and I can't find a solution to eliminate this unwanted line break.
This is very problematic for me; can someone help me with this issue?
Thank you in advance.

3 answers

  1.
    m@rina Posted messages 27916 Registration date   Status Moderator Last intervention   11 569
     
    Hello

    You give very little info and we don't have the gift of divination!

    Where is your line break? How do you paste?

    So I'll try to imagine: if the line break is after, it's probably because you're pasting as a Word table and not as an object, since after a table you can't have text and therefore you necessarily have a line break.

    If that's the case, when you paste, you need to display the Paste Special dialog box (Home tab => Paste => Paste Special), check "Paste link" and choose "Excel Worksheet" from the list.

    m@rina

    --
    It's useless to ask me your questions privately. I won't answer them.
    3
    1. AD922017 Posted messages 3 Status Member
       
      Hello,

      Thank you for your message.
      Indeed, upon rereading, I realize that I did not provide enough detail.
      Here are some clarifications:
      I have an Excel document in which I have entered a set of data in table form (2 columns, 50 rows). Additionally, I have a Word document template in which there is text (it is a contract) with elements that need to be populated by my Excel document.

      I use the function Link and keep source formatting or link and keep source formatting.

      Practical case:
      Text at the bottom of the Word Doc:
      Monsieur is in his garden.

      Element in my Excel file:
      Durand.

      What I want:
      Monsieur Durand is in his garden.

      What I get with my method:
      Monsieur

      Durand

      is in his garden.



      There is my problem; I have one/two line breaks, the same after integrating the text from my Excel cell.
      0
  2. AD922017 Posted messages 3 Status Member
     
    Hello,

    Indeed, upon rereading, I realize that I did not provide enough detail.
    Here are some clarifications:
    I have an Excel document in which I have entered a set of data in tabular form (2 columns, 50 rows). Additionally, I have a Word document template in which I have text (it is a contract) with elements that need to be filled in from my Excel document.

    I use the Link and keep source formatting or link and keep source formatting function

    Practical case:
    Bottom text of Word Doc:
    Mr. is in his garden

    Element in my Excel file:
    Durand

    What I want
    Mr. Durand is in his garden

    What I get with my method:
    Mr.

    Durand

    is in his garden

    There is my problem: I have one/two line breaks, the same after integrating the text from my Excel cell.
    0
  3. m@rina Posted messages 27916 Registration date   Status Moderator Last intervention   11 569
     
    Ah this time, we have the explanation in double!!! :)))

    So this is what I thought. You must therefore use the solution I provided you.

    m@rina

    --
    There's no need to ask me your questions privately. I won’t answer them.
    0