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

How to April 14, 2021 BlogzBite Team 4 15.59K

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

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.

World Hindi Day (विश्व हिंदी दिवस): विश्व हिंदी दिवस क्या है?, राष्ट्रीय हिंदी दिवस, विश्व हिंदी दिवस से कैसे अलग है? जानें इसे 10 जनवरी को मनाए जाने का कारण और उद्देश्य

How to insert Audio in PowerPoint 365 for Windows

How to Add Units to Numeric Values in Excel for Better Data Presentation

Phrasal Verbs with examples (part-1)

Courses to pursue after becoming CA

VIVO IPL 2021: Schedule, Team, Venue, Time Table

Fixed Prepositions with Examples (List -1)

Biography of Satya Nadella (His childhood, education, career, personal life, achievements, what can one learn from his life)

Evelyn

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 Reply

Mauricio

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

December 10, 2022 Reply

RAJ SINGH

Very useful,

April 17, 2021 Reply