copy doument names from a file into excel
Like the names of files in a folder?
If yes, then I use this technique:
I open a command prompt:
Windows start button|Run
cmd
(in windows xp)
and hit enter.
Then I traverse to the drive and folder that contains the files.
I type:
dir c:\myList.txt
This creates a text file in the root drive of my C: drive (away from the folder
with the names).
Then I close that window.
Open excel and use File|Open to open that text file.
After I'm done, I can clean up that .txt file.
Lizndc wrote:
I'm trying to copy 171 document names only into an excel spread sheet so that
I can then talk about the status of each document I don't seem to be able to
copy this information and then paste it into excel
I've tried Ctrl shift ctrl C ctrl V and nothing happens I've tried the Copy
function from the drop down menu but the paste option doesn't appear in excel
--
Dave Peterson
|