Unwanted line break when copying/pasting from Word to Excel
AD922017
Posted messages
3
Status
Membre
-
m@rina Posted messages 27323 Registration date Status Modérateur Last intervention -
m@rina Posted messages 27323 Registration date Status Modérateur 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.
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 réponses
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.
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.
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.
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.
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.