CONCATENATE Function
Written by kazamraza
no comments
Classified in : Excel Formulas, Text Functions
This function is used to join two or more text strings into one string.
Syntax
CONCATENATE(text1, [text2], ...)
for example
=CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.")
=CONCATENATE(B2, " ",C2)
Note: space is also a character.
◢ | A | B | C | D | E |
---|---|---|---|---|---|
1 | First Name | Last Name | Formula | Result | |
2 | Kazam | Raza | =CONCATENATE(A2," ",B2) | Kazam Raza | |
3 | Kazam | Raza | =A2 & " " & B2 | Kazam Raza | |
4 |
We can combine text strings by using CONCATENATE Function as well as & (Shift +7) sign. To add space between text strings use inverted commas with space like " ".