Question

How use the function concatenate in excel?

Answer 1

1- Select the cell where you need the result.
2- Go to formula bar and enter data range ex. =TRANSPOSE(A1:A5)&” “
3- Based on your regional settings, you can also try =A1:A5 (instead of =TRANSPOSE(A1:A5)).
4- Select the entire formula and press F9 (this converts the formula into values).
5- Remove the curly brackets from both ends.
6- Add =CONCATENATE( to the beginning of the text and end it with a round bracket).
7- Press Enter

Answer 2

♡♡♡Hey mate!!!!♡♡

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Before knowing how to use concatenate we should know what actually concatenation is???

☆☆ So, concatenation means to combine or join together. We use this function to combine text from different cells into one cell. ☆☆

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

So now coming to the question:

♡♡ Here are the detailed steps how to use concatenation...♡♡♡

=================================

• Select a cell where you want to enter the formula.

• Type = CONCATENATE in the cell.

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

• Release the control button and press enter.

================================

By ...TANU. .❤