Question

what is used as concatenation operator in excel​

Answer 1

Answer:

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.

Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.

Answer 2

Answer:

&" operator to concatenate strings in Excel

Similarly to the CONCATENATE function, you can use "&" in Excel to combine different text strings, cell values and results returned by other functions.