How Excel Multiple-column content is merged and the middle string is added

That's the easiest thing to do.

=a1& "," &b1 very simple.

Using the CONCATENATE function

H2=concatenate (C2, "/", D2)

So, if you encounter a space in the data, that is, there is no data in the current row, how to operate it? The principle is the same.

Look at the following function

H2=substitute (TRIM (c2& "" &d2), "", ",")

This should not be difficult, the form function on it, the back is still complicated, then say it later!

By the way, this is the operation of a cell, the function input well, if the hundreds of thousands of data down, fill the formula is OK, now I need hundreds of thousands of data a table, that hand is not sour dead? Since Excel is so powerful, this problem developer should not forget it?

Find the relevant information, the next method, we look at it: how to quickly fill the formula

The method is also very simple, in the last I said a method, is to use shortcut keys to automatically increase the number of IDs, the method is actually the same

For example, we fill the cell with a formula, then select the H2, and then hold down the SHIFT key to not let go, to the last cell click on, you can quickly select the entire column, this everyone, this time, the mouse moved to the function formula column:

Then press the combination shortcut key Ctrl + ENTER (enter) to complete the full fill

Classification:

• Excel Tutorials