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 Google Plus

About Nifty Guru

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Saturday, June 13, 2009

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

Function Concatenate()SocialTwist Tell-a-Friend

0 comments:

Post a Comment