CONCATENATE Function

Written by kazamraza no comments
Classified in : Excel Formulas, Text Functions Tags : none

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 " ".

 

 

 

 

 

 

 

 

 

 

 

 

.