# Concatenate formula in Microsoft Excel

http://www.exceltip.com/excel-keyboard-shortcuts/combining-text-from-different-cells.html

In Excel merge the cells by using the Concatenate function. To combine excel text formula from different cells or to merge data in excel “CONCATENATE” formula is the best way.

CONCATENATE function allows to join the cell text from multiple cells into a single cell.

Let’s take an example and understand how we can combine text cells in excel from different cells.

Example 1: We have data in range A1:B11, in which the 1st text string is in column A and the 2ndin column B. To combine both the text in excel strings into one cell follow the below given steps –

• Select cell C2
• Enter the formula =CONCATENATE(A2,” “,B2)
• Press enter on the keyboard.
• The function will combine the text from cell A2& cell B2 into C2, separated by a space.
• To combine the text for the rest of the cells, copy the formula.
• Press key “CTRL + C”after selecting the formula cell and select the cell C3 to C28 and press key “CTRL + V”on the keyboard.

To combine the text from different cells you can use another formula too:-

• Select the cell C2
• Enter the formula =A2&” “&B2.  Here the & symbol is the joining character between the text string in A2, the space and the text string in B2.
• Press enter on the keyboard.
• The function will combine the text from A2 and B2 in a single cell C2, separated by a space.
• To combine the text for the rest of the cells, copy the formula.
• Press key “CTRL + C” after selecting the formula cell and select the cell C3 to C28 and press key “CTRL + V” on the keyboard.

Here, we have reviewed the joining of 2 strings.  But we can also join multiple text strings into one string, provided the total text in the cell does not exceed 255 characters.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at [email protected]

0

## 12 thoughts on “Concatenate formula in Microsoft Excel”

1. thank you very much it is very useful for me
thank you verymuch
are you help me to how will remove the password lock of the cells in the excel

2. Can we have there combined values from two cells inside one? like the 3rd cell value is “Name is [Column 1] whose designation is [Column 2] is currently [column 3]“…
Is it possible?

• sorry for, but you can add any number of string values in another cell by separating cell name with & character
e.g., C32=B1&” “&B2&” “&B3&” “&B4&……..