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

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")
  ),
  "."
)
  1. WEEKDAY(...) returns the weekday number for the given Date or DateTime value: 5
  2. INDEX({...}, ...) uses the weekday number to retrieve the weekday name from a list of weekday names: Thursday
  3. CONCATENATE("Today is ", ..., ".") assembles all of the parts into the final text: Today is Thursday.

See also: INDEX(), , WEEKDAY()

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.

See Also

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

Did this answer your question?