special copy/paste
I have a lot of entires which are in a list in a txt file (so each entry is on a seperate line in the txt file) and these entries need to be copied into an excel column with each entry having its own cell
a standard copy/paste just puts the whole list in one cell
how can i copy/paste it so that each entry in the list is put in a seperate cell in the column - i dont want to go through them one by one because its a very long list
|