Question

give example of the text data type in excel and how can they be concatenated using operator of Excel​

Answer 1

Two text in two different cells can be joined using Concatenate . In a cell , just type this function -

=CONCATENATE(CellAddress1,CellAddress2)

Answer 2

Answer:

With the help of concatenate function and & operator in excel, we can concatenate the two texts of different cells.

Explanation:

Excel offers many useful features. Out of which concatenate function is the feature in which we can concatenate or join two text or strings present is two different cells. The simplest syntax for concatenating two texts is =concatenate (A1, B1).

We can also concatenate a string with a numerical value. We can also use & operator in excel to join two cells.