Excel create a new folder in bulk?

Many people in the work will encounter the need to create a large number of folders, such as people who do personnel work may have to put everyone's information in the folder, a creation, naming too troublesome, tired and inefficient. This article will explain a simple and quick way to you. We can use Excel to create folders in bulk.

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.

▲ Figure 1

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.

▲ Figure 2

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.

▲ Figure 3