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.

image 2
 
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.

img1
 
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.

img2
 
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.

 

image 48

 

 
 

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

 
 



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?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>