Hello,
I try to copy a Word table into Excel, and keep the Word initial format (text color for example), and the same structure (means 1 cell in the Word table = 1 cell in the Excel sheet).
But I have the following result:
WORD:
EXCEL:
while I intended to have all text of column B, in the signle B1 cell...
I have tried manually, with a VBA macro, but not possible to have the good result.
It seems that if there is carriage return, Excel change the row during the paste operation.
Havy you any idea if what I want to do is feasible or not ?
NB: Another idea would be to merge content afeterwards, from B1 to B7, But this is not functionning and only keep the single content of the cell B1
Thank you...
I try to copy a Word table into Excel, and keep the Word initial format (text color for example), and the same structure (means 1 cell in the Word table = 1 cell in the Excel sheet).
But I have the following result:
WORD:
EXCEL:
while I intended to have all text of column B, in the signle B1 cell...
I have tried manually, with a VBA macro, but not possible to have the good result.
It seems that if there is carriage return, Excel change the row during the paste operation.
Havy you any idea if what I want to do is feasible or not ?
NB: Another idea would be to merge content afeterwards, from B1 to B7, But this is not functionning and only keep the single content of the cell B1
Thank you...
Last edited: