In Short: This function is used to join two or more text strings into one text string.
Explained:
This function is used to join two or more (maximum up-to 255) text strings.
But apart from using this function, we can also use the ampersand operator to join strings.
For joining text strings from any other cell, we should directly enter cell reference, but if we need to write something to join, it should be done under double quotes ("").
To insert space in between, we can join by entering " ", i.e. space between double quotes.
The following example further depicts the same.
Explained:
This function is used to join two or more (maximum up-to 255) text strings.
But apart from using this function, we can also use the ampersand operator to join strings.
For joining text strings from any other cell, we should directly enter cell reference, but if we need to write something to join, it should be done under double quotes ("").
To insert space in between, we can join by entering " ", i.e. space between double quotes.
The following example further depicts the same.
 |
| Add caption |
No comments:
Post a Comment