Function Concatenate()

Concatenate()

This function concatenate (joins) two or more text strings, including numbers and other symbols in text format

Syntax:

= Concatenate (Text1, Text2, Text...)

Text1, Text2, Text.. = are the text strings which are required to be contactenated

Example:

• = Concatenate ("Excel", "Matic") - result will be -ExcelMatic
• = Concatenate ("Excel", " ", "Matic") - result will be -Excel Matic (note the space between words)
• = Concatenate ("Excel", " ", "Matic", " 5.2") - result will be -Excel Matic 5.2

Note: The results of Concatenate() function can also be achieved by using '&' symbol. It also performs the function of joining the text strings and numbers. Similar to Concatenate, '&' also converts the numbers into text format

Example:

• = "Excel" & "Matic" - result will be -ExcelMatic
• = "Excel" & " " & "Matic" - result will be -Excel Matic (note the space between words)
• = "Excel" & " " & "Matic" & " 5.2" - result will be -Excel Matic 5.2

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.