Today, I faced a problem, i have to copy around 20 *.txt files name into an excel sheet in windows xp.
first few minutes, i was manually coping the file name from each file and then paste it in the excel.. It lead to lot of error..
I googled for any solution, i found a good solution from the microsoft site.
(unfortunately, i am not able to find the same site again)... but the steps are,
a) use the command prompt (start->run->cmd)
b) in the cmd prompt go upto the folder where the files are there
c) dir *.txt
d) right click on the listed file names and select mark
e) press enter (it will copy)
f) then paste it
This information may be too old.. but today only i learned it, so thought to share it...
first few minutes, i was manually coping the file name from each file and then paste it in the excel.. It lead to lot of error..
I googled for any solution, i found a good solution from the microsoft site.
(unfortunately, i am not able to find the same site again)... but the steps are,
a) use the command prompt (start->run->cmd)
b) in the cmd prompt go upto the folder where the files are there
c) dir *.txt
d) right click on the listed file names and select mark
e) press enter (it will copy)
f) then paste it
This information may be too old.. but today only i learned it, so thought to share it...
you can use dir /b | clip to copy the file name to clipboard
ReplyDelete