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 1^st text string is in column A and the 2^ndin 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

Remi Harris
March 15, 2016 at 10:47 am

many thanks

Reply ↓
aderemiharris
March 15, 2016 at 10:45 am

Thank you for the tips. It worked great!

Reply ↓
Bismaya
September 26, 2015 at 7:34 am

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

Reply ↓
Bismaya
September 26, 2015 at 7:32 am

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

Reply ↓
Mahi
June 1, 2015 at 5:24 am

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

Reply ↓
Bilal
July 2, 2014 at 9:14 pm

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?

Reply ↓
- shaheen
  September 18, 2015 at 5:03 pm
  
  of course you can by separating it with , or ampersand &
  
  Reply ↓
  - shaheen
    September 18, 2015 at 5:21 pm
    
    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&........
    
    Reply ↓
Vijay Ram Murugan
October 1, 2013 at 1:29 am

thank you
i want help to remove the cell lock with password

Reply ↓
Vijay Ram Murugan
October 1, 2013 at 1:28 am

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

Reply ↓
Daniel
August 27, 2013 at 9:42 am

Cool feature. Worked great.

Reply ↓
Ron
August 23, 2013 at 11:09 am

Cool feature. Worked great.

Reply ↓