For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. The next value is our cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties. As part of our sentence, our first value to be concatenated is “ Total Sale of “(including space after). We must insert an equal sign in cell C2 to start the concatenation.

In the above sentence, we have only two values available with cells, i.e., bold values-the remaining values we need to add as our own. In the sentence column, we need to create a sentence like this – We can enter our values with cell values, much like inserting space characters. Example #3 – CONCATENATE Cell Values with Manual Values However, the CONCATENATE formula is not popular among Excel users thanks to the ampersand symbol. It is the most commonly used method to concatenate values in Excel. For the same example of combining “Good Morning,” we can use the formula below.Īfter each value, we need to put the ampersand (&) symbol. We can use an ampersand symbol to concatenate values. Why do we want to use the CONCATENATE function where we can use the AMPERSAND (&) symbol as an alternative?

Once the space character is inserted, we will get the following result.Įxample #2 – Use the Ampersand (&) Symbol as the Alternative.

After selecting “Text1” in the “Text2” argument, we need to supply the space character in double-quotes as ” “.

So, while applying the formula after selecting Text1, we must insert a space character as the second value to be concatenated before choosing Text2.

We have selected two values above, so the concatenate function combines these two values. So close the bracket and press the “Enter” key. Next, select cell A2 as the second argument (Text2).Then, we must select cell A1 as the first Text1.

First, we must open the concatenate formula in cell A4.

In cell A4, we need to combine these two and create full sentences such as “Good Morning.”

Concatenate in openoffice excel