Let’s go back to Bob’s problem.
Although Bob knows now about the ‘CONCATENATE’ function in Excel, it doesn’t mean his problem will go away. He has to know how to apply the formula to the succeeding cells below the column.
There are two ways to do this:
- Copy-paste the cell with the syntax to all the cells in the entire column
- Drag the fill handle down to copy the formula to other cells
To copy-paste, just select the cell with the syntax and hold CTR + C. To paste the formula to cells, select the cells then hold down CTR + V.
To use the fill handle, just click the cell with the syntax and drag the handle on the bottom right side of that cell down.