2. Select the first editable row of the new column and enter the formula. I want the splicing value of the second row of column A and the second row of column B, so the formula = a2 &；; B2。 Write the equal sign!
3. Select the cell that just got the value and drop it down directly.
Step 4: Complete