Create folders in batches using Excel_Teach you a trick to save time and effort

In daily work, we need to create multiple folders in batches. It is very troublesome to create them one by one manually. How to improve efficiency? PHP editor Baicao teaches you a trick to use Excel to create folders in batches. The operation is simple and saves time and effort. For specific operation steps, please continue reading the following details.

1. First, we enter the name of the new folder in a column of the Excel table.

2. Then right-click on the first cell and select Cell Format, select [Customize] in the category, delete the common format in the type, and fill in "md "@

Note here The double quotes must be in English format. There is a space before md.

3. Then click OK, drag the first cell down to the cell below and paste it, and then select the paste format as fill format only, so All cells are preceded by md.

#4. Then create a new txt document in the directory where you want to create a new folder, copy all the file names in the list, save and close the txt.

5. Finally, change the suffix name of txt to bat, and double-click to run. In this way, the folder will be created.

How about it? Isn’t it very simple? In this way, you can create as many folders as you like. Create as many folders as you want. It’s very simple. Friends who don’t know, please hurry up. Go try it.

The above is the detailed content of Create folders in batches using Excel_Teach you a trick to save time and effort. For more information, please follow other related articles on the PHP Chinese website!