A graphic method for creating folders in batches in Excel

1. Enter the name of the folder to be created in a column of the Excel table.

2. 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 that the double quotes here must be in English format. There is a space before md.

3. 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 that all cells They all have md in front.

4. 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.

The above is the detailed content of A graphic method for creating folders in batches in Excel. For more information, please follow other related articles on the PHP Chinese website!