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.

I have addresses in a text file, and they're all on different lines (see 1st Image).

When I copy and paste this data to an excel file, they all appear on different lines, not matter how much I try to get it into a single cell. I have word wrap checked.

However, if I remove the line breaks in the text file and then do a copy and paste, all the data appears in a single cell. I have to add line breaks in the cell manually.

There are some 500+ addresses. Do you know how I can do this without having to remove line breaks and add then all over again?

enter image description here

enter image description here

share|improve this question

migrated from stackoverflow.com Jan 10 '13 at 9:23

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

up vote 4 down vote accepted

If you double click the cell (so that you are editing its contents rather than just selecting it) and then paste, it will paste the data in with the line breaks intact.

share|improve this answer
    
LOL. And I struggled with this for two days. –  Norman Jan 10 '13 at 4:39
    
@norman It's cool. I remember when I first had this issue and it perplexed me for a while too! –  Nick Perkins Jan 10 '13 at 4:39
    
Well, Thanks for helping. –  Norman Jan 10 '13 at 4:40
add comment

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.