So I have a table in MS Word which has two columns. In the second column the text is spread on multiple lines, ie I have pressed 'Enter' to achieve this.

When I paste into Excel, it converts these separate lines into separate cells.

What I want it to do is to keep the lines in the same cell, just on different lines, ie what would happen if I were to press Alt+Enter in a cell in excel.

How would I go about this?

Edit: here's an example of my data. In word it's in a word table.

----------------------------
| Bananas   | - yellow     |
|           | - curved     |
----------------------------
| Apples    | - red/green  |
|           | - round      |
----------------------------
link|improve this question
in word how are the cells separated? also with [enter] ? or is it in a word-table? – madmaze Dec 22 '10 at 16:56
It's a word table. – Sean McRaghty Dec 22 '10 at 19:30
feedback

1 Answer

Pasting won't work. Alt+Enter in Excel isn't a special character, it's only a way of ensuring a CR+LF is stored within a cell rather than forcing you into the next cell.

One option would be to not press Enter in your Word table but use another character instead (e.g. '#') and then use a macro in Excel to search for '#' and replace with CHR(10) once you've pasted.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.