Category: Text functions
What does this function do?
Joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items.Syntax:
CONCATENATE(text1, [text2], ...)
- text1 (required): The first text item to be concatenated.
- text2 (optional): Additional text items, up to a maximum of 255 items. The items must be separated by commas.
Examples:
=CONCATENATE(“I”, “ love”, “ excel”)= I love excel
If A1=1, A2=2 and A3=3
=CONCATENATE(A1, A2, A3) = 123
No comments:
Post a Comment