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


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.

| 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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