Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 Jan 10 '13 at 9:23

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .