CONCATENATE()

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

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false