excel+ Notepad Bulk New Folder

Sometimes we need to create a new folder or file in batches based on a bunch of names or ID numbers, and this tutorial applies. Principle, use the basic function of Excel to generate the cmd command in batches, then paste it into the bat file, double-click to execute.

1. Open Excel form:

2, in 2B cell input: = "MD" &a2

All familiar with the MD command knows that this command is the command for a new folder.

3, select 2B cell, drag down to the last line:

So you get a lot of MD commands.

4. Copy the contents of column B in the above figure to Notepad:

5. After saving Notepad, change the name to bat:

6, after the change, double-click the execution can be done. Try it, it works well?