Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Create Multiple Folders At Once— Simple And Effective Way

Date:2021-8-6 Author:Sandra

In our previous tutorials, we have learned how to create multiple worksheets in excel. And in today’s tutorial, we are going to learn how to create multiple folders at once.

Let’s also take months as an example. If we need to create folders and named them by month, from January to December.

We first type the months in an excel sheet, then type [= “MD” &A1] in cell A1. And use the fill handle to fill them.  Remember to press once Space key after MD.

How To Create Multiple Folders At Once--- Simple And Effective Way

Copy and paste the MD part into a new text document like below.

How To Create Multiple Folders At Once--- Simple And Effective Way

Then, we need to change the text document’s suffix “txt” into “bat”.

How To Create Multiple Folders At Once--- Simple And Effective Way

Hit Yes.

How To Create Multiple Folders At Once--- Simple And Effective Way

Now, the final but most important step. Double click the new text document.bat.

You will quickly get all the folders named by month.

How To Create Multiple Folders At Once--- Simple And Effective Way
How To Create Multiple Folders At Once--- Simple And Effective Way
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *