Question

4. Joining strings from different cells.​

Answer 1

Answer:

Press CTRL to select multiple cells to be concatenated

Select a cell where you want to enter the formula.

Type =CONCATENATE( in that cell or in the formula bar.

Press and hold Ctrl and click on each cell you want to concatenate.

Answer 2

Answer:

1) select the cell from where you want the formula .

2) Type = CONCATENATE ( in that cell or the formula bar.

3) Press and hold Ctrl and click on each cell you want to concatenate .

4) release the button Ctrl , type the closing parenthesis in the formula bar and press enter.