CONCATENATE
Joins several text items into one text item
Category : Text
Location : Built-in
 |
| Concatenate |
What Does It Do?
This function joins separate pieces of text into one item.
Syntax
=CONCATENATE(Text1,Text2,Text3...Text30)
Up to thirty pieces of text can be joined.
Formatting
No special formatting is needed, the result will be shown as normal text.
Note
You can achieve the same result by using the " & " operator.
 |
| Concatenate_1 |
Watch Video Click For More Details
Please Subscribe the Channel for more Excel formulas and VBA Macro Codes
