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?

excelFile.jpg

textFile.png