CONCATENATE()

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")
  ),
  "."
)

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, [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.

See also

INITIALS()

LEFT()

MID()

RIGHT()

SPLIT()

SUBSTITUTE()