Concatenate formula in Microsoft Excel

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.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
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 info@exceltip.com

1. i would like to comment thanks to excel provide the function "CONCATENATE"

2. Thanks to excel i would like to comment it so nice to provide the function "CONCATENATE"

3. This is really nice tip for Concatenate thanks to provide us such a good tip.

4. 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?

• of course you can by separating it with , or ampersand &

• 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&........

5. Vijay Ram Murugan

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

6. Cool feature. Worked great.

7. Cool feature. Worked great.

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.