Concatenate can join up to 30 text items and combine them to make one text.

How to add text strings together in excel. Select a blank cell says cell C2 adjacent to the cells you want to add together then enter formula A2 B2 into the Formula Bar and then press the Enter keyNote. An example formula might be CONCAT A2 Family. Below we have the text strings in A1 and B1.

Verify that we get the same result in above step3. If we want add strings in B2 after A2 just enter the formula CONCATENATE A2 B2. Adding 2 strings together is very easy in Excel.

Use commas to separate the cells you are combining and use quotation marks to add spaces commas or other text. Follow above step1 in cell C2 enter the formula CONCATENATE B2 A2. You can also concatenate cells together.

And means that the combined texts will be separated by space. Gmail yahoo hotmail rediffmail. This function allows you to combine text from different cells into one cell.

Range C1Value Range A1Value Range B1value. Add text cells together into one cell with formula 1. Here you can use the CONCATENATE function to merge cells together into one cell or you can simply use the ampersand symbol to join your text.

Introduced in MS Excel 2016 TEXTJOIN is categorized as an Excel StringText function. It combines strings and text together and is a built-in function in excel. Select the cell you want to combine first.