Skillfully add HTML content in bulk with Excel merge

Today's copy of the unit requires changes to the first page of some content.

These are about 20 lines of text, which are made into lists, and the text scrolls up the loop.

Although the IDE makes it easy to automatically generate 20 pairs of <li> </li> tags with ul>li*20, it is also tiring to have a single row of copies of the content in the manual.

Wit me, and immediately want to try Excel to improve productivity.

The file came in txt format, but copied into the powerful Excel, automatically divided into 20 lines. (The Microsoft programmer is really amazing!) Unexpectedly provide such a powerful software such a powerful function! ）

First, add 2 columns. Select the cell, the mouse moves to the lower right corner of the cell, the cursor becomes bold black cross, double-click the left mouse button, automatically copy the contents of this cell to line 20th.

OK, now we have 3 columns to merge. As long as a simple formula, you can take care of everything. = Column 1& column 2& column 3. Double-click the lower-right corner of the cell again to automatically copy to the bottom of the table.

So we get the contents of the red box, such as:

Copy the content into the IDE and get it done.

Wow. It's so wonderful.

Skillfully add HTML content in bulk with Excel merge