Syntax

CONCATENATE(part...)

Arguments

  • part (any type): A value to be included in the combined text. If not already a textual type, the value will be converted using TEXT().

Return Value

Text: A new value consisting of each part merged together in the order given.

Examples

CONCATENATE("Good", "morning", "!") : Goodmorning!

CONCATENATE("Good", " ", "morning", "!") : Good morning!

CONCATENATE("Good morning, ", [First Name], "!") : Good morning, Martin!

CONCATENATE([Last Name], ", ", [First Name]) : Sandwich, Martin

CONCATENATE("Today is ", MONTH("4/1/2010"), "/", DAY("4/1/2010"), ".") : Today is 4/1.

Include the Weekday Name

CONCATENATE("Today is ", INDEX(LIST("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"), NUMBER(WEEKDAY("4/1/2010"))), ".") : Today is Thursday.

  1. WEEKDAY(...) returns the weekday number for the given Date or DateTime value.
  2. NUMBER(...) ensures the resulting weekday number is properly treated as a number. Only needed if WEEKDAY() is used to compute the weekday number as done here; not needed if the weekday number comes from elsewhere, such as an existing column value or as a literal value.
  3. INDEX(LIST(...), ...) uses the weekday number to retrieve the weekday name from a list of weekday names.
  4. CONCATENATE("Today is ", ..., ".") assembles all of the parts into the final text.

See also: INDEX(), LIST(), NUMBER(), WEEKDAY()

See Also

INITIALS(), LEFT(), MID(), RIGHT(), SPLIT(), SUBSTITUTE()

Did this answer your question?