It is used to
combine or merge date in 2 or more cells
or add a value between 2 or more cells
Formula of Concatenate
=Concatenate(First Value,Second Value)
If value is text,we need to put inverted commas " "
Example 1
Download Excel File And Try
Example 2
Example 3
Example 4