What is concatenate?

Question

How can we use concatenate in excel ?

Ganapuram Suryakranth · Answer

Concatenate is one of the text function used to join two or more text strings into one string.The formula of concatenate function =CONCATENATE(B2, " ", C2)

Jaimin Trivedi · Answer

Concatenate is a type of text function used in excel. It is used to join multiple string in one string; string of text. The syntax for concatenate is as follows;
Syntax- concatenate(string 1, string 2, ....). let me make it more simpler by taking an example:
Given string: JAIMIN TRIVEDI; Total length of the string: 14 including space as well. Now to join both the string of text we will use concatenate function;
=concatenate("JAIMIN","TRIVEDI") ; " inverted commas are used as to join the strings. this will give the output as ; JAIMINTRIVEDI. here we can see that both the strings are joined and became as one string.

Saket Kumar · Answer

The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.
The syntax of Excel CONCATENATE is as follows:
CONCATENATE(text1, [text2], …)
Where text is a text string, cell reference or formula-driven value.
Concatenating the values of several cells
The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows:
=CONCATENATE(A1, B1)
Please note that the values will be knit together without any delimiter,
To separate the values with a space, enter " " in the second argument,
=CONCATENATE(A1, " ", B1)

Habiba Tabasum · Answer

Concatenate is to combine the contents of different cells, this can be done by using CONCATENATE function, and & operator can be used to combine strings.concatenation can be done by specifying the cells (A1,B1)

Deepak Avinash Abhishek · Answer

​The word concatenate is just "to combine" the two different string or word.

Varalakshmi R · Answer

concatenate is the one which is used to join two rows or columns..

Khushal Navlani · Answer

The word concatenate is just another way of saying "to combine" or "to join together". The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column.

Mansi Aggarwal · Answer

The arguments tell the CONCATENATE function what cells to combine. In our example, we want to combine the text in cells A2 and B2, so we'll make each of those an argument:
=CONCATENATE(B2, A2)
OK, let's run this function!

Akhilesh Rai · Answer

a.Select a cell where you want to enter the formula.
b.Type =CONCATENATE( in that cell or in the formula bar.
c.Press and hold Ctrl and click on each cell you want to concatenate.
d.Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.

Lisha Mondal · Answer

Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Akhilandeswari .V · Answer

The process of merging data literals is one of the core application of concatenate. The word concatenate is just another way to saying "to combine "or "to join together ".In Excel concatenate allows you to combine the text from different cells into one cell.

Umesh Sakhare · Answer

Concatenate use to combine two or more text string.

Satyabrata Roy · Answer

Concatenation is taking two or more separately located things and placing them side-by-side next to each other so that they can now be treated as one thing.

Shivank Parashar · Answer

Concatenate means to link things together in a chain or series.
Steps to use it in EXCEL:
1) Click the cell where you want to put the combined text.

2) Type  =(

3) Click the cell that contains the first text you want to combine, such as a person’s first name.

4) Type  &” “&  (a space enclosed in quotation marks).

5) Click the next cell with the text that you want to combine, such as the person’s last name.

Tadaaa!

Pappu Kumar · Answer

=concatenate(text&" "&text)

Rinku Kumar · Answer

CONCATENATE FORMULA USED IN COBINE TWO WORD IN SINGLE CELL.

Hemant Rishikesh Gund · Answer

Two Join Two String we use Concatenate Function

Shubham Sharma · Answer

Concatenate means combine the data of two or more cells into one cell.

Aakanksha Utekar · Answer

It is a formaula to combime more than one or more cells