Merged text from parts
Returns a new text value consisting of each part merged together in the order specified.
Sample usage
CONCATENATE("Good", "morning", "!")
returns Goodmorning!
CONCATENATE("Good", " ", "morning", "!")
returns Good morning!
CONCATENATE("Good morning, ", [First Name], "!")
returns Good morning, Martin!
CONCATENATE([Last Name], ", ", [First Name])
returns Sandwich, Martin
CONCATENATE("Today is ", MONTH("4/1/2010"), "/", DAY("4/1/2010"), ".")
returns Today is 4/1
.
Include the weekday name
Include the computed weekday name into a constructed statement:
CONCATENATE(
"Today is ",
INDEX(
{"Sunday", "Monday", "Tuesday", "Wednesday",
"Thursday", Friday", "Saturday", "Sunday"},
WEEKDAY("4/1/2010")
),
"."
)
WEEKDAY(...)
returns the weekday number for the givenDate
orDateTime
value:5
INDEX({...}, ...)
uses the weekday number to retrieve the weekday name from a list of weekday names:Thursday
CONCATENATE("Today is ", ..., ".")
assembles all of the parts into the final text:Today is Thursday
.
Syntax
CONCATENATE(part, [part ...])
part
- A value of any type to be included in the merged text. You can specify multiple parts enclosed in quotes and separated by a comma.