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.
CONCATENATE(text1, [text2], ...) for example =CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.") =CONCATENATE(B2, " ",C2) Note: space is also a character.
|1||First Name||Last Name||Formula||Result|
|2||Kazam||Raza||=CONCATENATE(A2," ",B2)||Kazam Raza|
|3||Kazam||Raza||=A2 & " " & B2||Kazam Raza|
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 " ".