Create a text document in bulk

A fairly simple and easy way to tell you:

1. Start Excel, copy the file name you have entered in column A, or enter it directly in Excel, a file name for the cell.

2. Enter the pathname in column B, if the path name is the same, just enter the B1 cell, and then fill it down (or you can do it without filling the back with an absolute reference).

3. Input:copy> in C1

4. Input in D1:

= $C $1&b1&a1& ". txt"

Get the content similar to "copy>e:\works\abc.txt" and fill the formula down to the last line.

5. Copy column D, after pasting in Notepad, save as a batch file, that is, the file type selected "All Files (*. *)", the file name suffix with ". Bat", can also be saved directly after the suffix name "bat".

6. Double-click on the saved batch file to complete the batch file creation.

Create a text document in bulk