Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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      |
----------------------------
share|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

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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