Step-by-step tutorial for adding / combining formulas in Excel

In Excel software you can merge cells using the Concatenate function . Using the ” CONCATENATE ” function is the best way to combine different cell text formulas or merge data.

The CONCATENATE function allows you to bring cell text from multiple cells into a single cell and link them together.

C: \ Users \ PC \ Desktop \ image-259.png

Let’s take an example to better understand how text cells can be combined.

Example 1: In the range A1: B11 have information (corresponding to the first row contains a description of the photo below), the first text string in column A and the second string in column B is located. To combine both text strings and put the result of this combination in one cell, follow these steps:

  • Select cell C2 (data is from the second row onwards).
  • Enter the formula CONCATENATE (A2, “”, B2) in that cell.
  • Press enter on the keyboard.
  • This function combines the text of cell A2 and cell B2 and writes inside cell C2 with a space between them.
  • Copy the formula to combine the text of the other cells.
  • After selecting the formula, press “CTRL + C” and select cells C3 to C11 and press “CTRL + V” on the keyboard.

C: \ Users \ PC \ Desktop \ img157.jpg

You can use another formula to combine the text of different cells:

  • Select cell C2 .
  • Enter the formula A2 & ”“ & B2 . Here & is the symbol of the connection between the text string in A2 and the text string in B2 .
  • Press enter on the keyboard.
  • This function combines the text A2 and B2 in cell C2 and separates them with a space.
  • Copy the formula to combine the text of the other cells.
  • After selecting the formula, press “CTRL + C” and select cells C3 to C11 and press “CTRL + V” on the keyboard.

C: \ Users \ PC \ Desktop \ img248.jpg

In this example we have combined 2 strings. But if necessary, we can combine several text strings into a text string, provided that the total text in the cell does not exceed 255 words.

Leave a Reply

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