CONCATENATE Excel Formula A simple formula to bring the text of multiple cells into a single cell
Usage of Excel Formula CONCATENATE
How to Apply CONCATENATE Excel formula ?
1) Join 2 Cells –
In the List below, the names in 3 different columns B, C, D are middle characters and last names. Apply this formula in the next cell. In cell F5, press the sign of = type CONCATENATE and open the bracket.
We will see the highlights of the formula Text1, text2,. Click on the first name cell C5 and press comma, then click on cell C6. We will take only two cells here. Close the bracket. You can add up to 255 cells if you want. Finally press enter.
3. Join Including Space
3. Join Multiple Cell Including Space
Similarly, we can add multiple text …
=CONCATENATE(C7,” “,D7,” “,E7)
4. Join Cell including Special Characters
We can also put a special character in the middle of two text. Just like we have given space in double inverted comma, similarly we have to put special character in double inverted comma.
We can also take a space special character from a different cell. In this, we only have to click the cell with a comma in the middle.
5. Join numbers (Ex.7)
This formula also adds different numbers.
Excel Function Paste Special
Just paste the value or text out of the cell’s formula
Information derived from any formula is only visible to us. If you copy the cell of the formula, then only the formula is copied. If we want to paste the text or value in different place or in the same place, then paste special can use this excel function.
Copy all the cells in the formula.
Click on the first cell wherever you want to paste. Right click the mouse. Click on the 123 is symbol of the paste value.
clicking on the values and clicking on OK.
The formula will be removed and only the text or value will be pasted.