A question about how to copy folder details to excel.

Asked By YOUNG HERNANDEZ 30 points N/A Posted on - 12/22/2012

 

 

Hi techyv,

A question about how to copy folder details to excel. How can I copy those folder details to my Microsoft Excel spread sheet? Is there a way to automatically merge those data and make them as one? I am just wondering about the process.

Hoping for your help. Thanks.

• Status: Open
• Question Views: 907
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Claraj jane 10 points N/A #165952

A question about how to copy folder details to excel.

 

Hi,

Follow these steps.

1. Click on start and in search type cmd and press enter.

2. Go to the Drive in which your folder is save.

3. Now type in for example C: cd abcfolder to go to your folder.

4. Now type in it C: new.txt and press the enter.

5. Now close the dos window.

6. Go to the folder in windows and drag the file new.txt into excel window.

7. In excel go to the Tools.>Data.>.>text to column.

8. Select delimited and next.

9. Use space as separator.

About Claraj jane

Questions
1

Answers
215

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 12/24/2012
• Question Category: MS Excel