Skillfully use Excel to create folders quickly in batches

Because of the need for work, often to create some names folder, a very cumbersome to create, in fact, we can use Excel to create a lot of folders.

First, open Excel to create a new worksheet, enter "MD" in column A of the table (followed by a space), column B Enter the path to the folder you want to create, c column to enter the name of the folder, you can manually or copy paste to enter the names.

In the second step, enter "=A1&B1&C1" in column D, and then pull the anchor in the lower-right corner of the cell so that the table below it is automatically populated.

The third step, the creation of a text file, the contents of the D column copied to the text file, and the file suffix from "txt" to "bat", and then double-click the file can be completed by the bulk of the folder created.