Creating 50 Folders and naming them with student names is a hard task, but I must do it to save assignments for each student in a separate folder.
Here is how I am going to do it in 3 steps:
Step One ► Excel
In an Excel spreadsheet, I have a long list of student names in columns A and B.
I start by creating a calculated column in column C in which I combine the First and Last names (that will be the name of the Folder, preceded by “MD “ which stands for “Make Directory”.
Note the space after the D in “MD “
My formula will be:
=”MD “&A2&”_”&B2
Copy the formula down to the entire list of students (whatever the number of students)
Copy all the results of the formula in column C
Step Two ► Notepad
Open Notepad
Paste in Notepad what you copied from Excel.
Save the Notepad file in a separate empty folder (could be on your Desktop) that you created for this project. I have a folder named My Students on the Desktop.
When saving the Notepad file, the name should end with ► .bat
I will name my file ► Assignments.bat
Close the Notepad file
Step Three ► Open File Explorer
Navigate to the folder you previously created on the Desktop (mine was named My Students) and open it
You will find the Notepad file (created in Step Two) Assignments.bat as a Folder.
Watch the magic Now:
Double-click on that folder, and instantly a folder is created for each student and named with First and Last names.
Isn’t that spectacular?
Watch it on TikTok (59 Sec)
@officeinstructor.com Create Multiple Folders From Excel Data in 1 Step
♬ original sound - Nabil Mourad
