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?