I have a table in word that I'm trying to copy into excel.
The problem is one of the columns in the row in that table may have multiple lines with hard returns.
When I copy and paste into excel, the result gives me multiple lines. I want a single line, with the exact multiple text in a single cell. How can I do this?? Nobody in the world seems to know.
To try this set up a word table with a single row, 3 columns. In the 3rd column put the following value.
Value 1
Value 2
Value 3
Now copy the entire row and attempt to past into excel. Watch as it creates 3 rows.
Thanks in advance!
The problem is one of the columns in the row in that table may have multiple lines with hard returns.
When I copy and paste into excel, the result gives me multiple lines. I want a single line, with the exact multiple text in a single cell. How can I do this?? Nobody in the world seems to know.
To try this set up a word table with a single row, 3 columns. In the 3rd column put the following value.
Value 1
Value 2
Value 3
Now copy the entire row and attempt to past into excel. Watch as it creates 3 rows.
Thanks in advance!
