#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi,
Why don't you try opening the file in an excel format. When the txt file is closed, right click with the mouse, choose "Open With" and then select Excel from the list. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy and paste not working | Ellie | Word | 3 | 11-07-2013 02:23 PM |
Using Paste/Special wih Excel data | chickasaw | PowerPoint | 0 | 02-05-2010 10:00 PM |
Copy & paste low resolution | worriedme | Drawing and Graphics | 0 | 06-01-2009 03:05 AM |
Copy and paste special | Dace | Excel | 2 | 02-16-2009 12:18 PM |
Copy/Paste Question | rcdeacon | Word | 2 | 12-20-2008 09:11 AM |