How To Create Folders Quickly Based On Cell Values In Excel?

How To Create Folders Quickly Based On Cell Values In Excel?
 How to        April 14, 2021         BlogzBite Team       4       15.82K

Hello friends, welcome to be here.In this lesson, you are going to learn “how to create many folders in single minute by excel?”

Sometimes we need to create many folders and we create them one by one but it takes long time. Supposing you have a list of various courses in a range of a worksheet, and now you want to create some folders for each of them in the cells to record their information. If you create the folders one by one, it will waste a lot of time. But how could you quickly create these folders? Today, I will introduce you some quick tricks.

So, let’s begin lesson 

Firstly, we are to select a name’s list of folders as given below

Now, here we describe three methods to create a folder.

First Method: 
We are to use a formula which is
 ="MD "&CHAR(34)&selectcell&CHAR(34)

Second Method: 
In this method, we are to use CONCATENATE formula is given below
=CONCATENATE(MD,“ ”,“,Spoken English,”,)

Third Method: 
This is used for those, who has office -2010 and upper version. Its name is Flash Fill. Its shortcut key is Ctrl + E
Here we are to type in blank cell     MD “Any Name” after this press Ctrl + E

Finally, We have completed all three steps. After all these ways or steps are mentioned above, in each of steps we will get same result is given below.

Okay, it’s done. Copy all cell value first & then open Notepad .

Now paste it in notepad and save it with any name with .cmd extension (like: - TILS.cmd)

Now it is going to be completed, we are to go to location where we saved it & double click on it. After clicking on that file, all folders will get created.

So, friends, it is so easy to make or create many folders in one go, you can create 100+ folders, 200+ folders or you can create that how many you want to create. But at the condition that you must have name’s list of folders which are going to be created as folders.

Please watch video 

BlogzBite Team

About the Author

BlogzBite Team

Blogzbite has more than 50 experienced and budding content creators and bloggers under its umbrella and they work with a same mission to provide credible, correct and concise knowledge to the visitors.

Post a comment:


Success!! Thank you so much. This is the 4th website I've visited and this one finally worked for me. Saved me a lot of time.

 January 10, 2023


Awesome....super helpful...thanks for your very clear and accurate explanation. this is what exactly I needed =)

 December 10, 2022


Very useful,

 April 17, 2021

BlogzBite Team

Thank You, Please Subscribe our Newsletter and get latest updates

 April 17, 2021