How Excel Bulk Transcribe folder names

year-end summaries are about to begin, and many companies need to start sorting out their work totals for a year. For the specific handling of this matter, how to put the various content such as mountains and input, is a very headache things. For example, the summary name of each job, how to extract it from each folder into Excel or Word? Small knitting has a good idea, let you take a minute to fix these tedious things.

First, select the folder where you want to enter the name, and then click Home to choose the copy path.

Then open the Word document and select Paste to copy the path of the folder names to Word.

Press Ctrl+h to open the Find and Replace window, fill in the "Find What" (English half-width quotes), "Replace with" to fill in a blank and click Replace All. After success, you will be prompted to replace the text, check the document, there should be no more quotes.

Next, select all the document text (CTRL + a) and toggle the tab to the Insert page and click "Convert Text to table".

Pop-up window, tick the bottom of the "other characters", enter "" and click OK.

At this point, all the items are summed up in a different table column, select the last column to copy the name of the folder, copy it to Excel. What, is it easy?