Concatenate function used with text function, joins two or more text / numbers into one
Concatenate function used with text function, concatenate function joins the two or more than two cells / texxt into one by using special character &
Text Function - Text function used to change the way a number appear,
it normally used while you combine a text with numbers or dates