Pasting multi-line data from Word into Excel
Posted on 2003-02-19
I am trying to paste multi-line text from Word into Excel.
Excel (97) decides that the data would look nicer in separate cells, breaking between cells at each Line Break character.
This isn't what I want! I have tried replacing hard line breaks with soft line breaks in Word, but it doesn't help.
For some strange reason, Excel uses ALT-ENTER as its soft line break, whereas Word uses SHIFT-ENTER. But I can't generate ALT-ENTER in Word (the key combination doesn't work) and if I paste an ALT-ENTER from Excel into Word, it appears as a ENTER hard line break.
Any ideas how to get Excel to paste one block of text (containing ENTER characters) as one cell?