I have a lot of data in a text file and I’m trying to figure out the fastest way to convert what are individual lines in the text file to a single cell entry. Instead of having Name, Address, and Phone in three separate cells, I am trying to get each Person to have a single cell with all three of those entries on a new line WITHIN the cell.
So I want to turn the left side into the right side:
The left side is what is getting imported, the right is what I want
I would love if there was an automated way to do this (a macro or anything else) since I have to do this so often.
