Excel tutorial How to bulk Create a People name folder

In fact, we can use Excel to create a lot of folders, specific how to make, then please continue to see the specific steps of the operation Bar!

First step

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, where you can manually or copy and paste to enter the names.

Second Step

Enter "=a1&b1&c1" in the D column, and then pull the anchor point in the lower-right corner of the cell to automatically populate the table below it.

Third Step

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

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join