CONCATENATE

Formulas / CONCATENATE
Joins strings of text together.
=CONCATENATE(text1, text2, [text3], ...)
  • text1 - text to be joined
  • text2, ... - [OPTIONAL] additional texts to join

Examples

  • =CONCATENATE(A1," ",B1) // returns the same result as manually concatenating using =A1&" "&B1

    This is an example of how the CONCATENATE function can be used to achieve the same result as manually concatenating two cells using the ampersand (&) operator.

  • =CONCATENATE("Date: ", A1) // returns "Date: 44378" if A1 is 1-Jul-2021

    This is an example of how the CONCATENATE function can be used to concatenate a string with a cell containing a date. The date is returned as an integer.

  • =CONCATENATE("The date is ",TEXT(A1"mmmm d")) // returns "The date is July 1"

    This is an example of how the CONCATENATE function can be used to concatenate a string with a cell containing a date, and how the TEXT function can be used to format the date before concatenating it.

  • =CONCATENATE(A1:D1) // does not work

    This is an example of how not to use the CONCATENATE function. This example does not work because CONCATENATE cannot be used to join two ranges.

Summary

The CONCATENATE function is a Sourcetable text function that returns a single string of text by joining multiple strings together.

  • The CONCATENATE function returns text by joining up to 30 values together.
  • Note that you should use CONCAT or TEXTJOIN instead of CONCATENATE.
  • CONCATENATE works with can be text strings, numbers, or cell references but does not handle ranges.
  • The ampersand (&) may be used instead of CONCATENATE. Some prefer using the ampersand (&) in place of CONCATENATE because it is easier to read and makes for shorter formulas.


Frequently Asked Questions

What is the CONCATENATE function?
in Sourcetable, the CONCATENATE function takes multiple strings of text and joins them together into a single string.
What is the difference between CONCAT and CONCATENATE?
CONCAT replaces CONCATENATE in Excel 2016, Excel Mobile, and Excel for the web. CONCAT and CONCATENATE work in similar ways, but CONCATENATE has been kept around in Sourcetable for backward compatibility.
Will CONCATENATE be available in later versions of Excel?
While CONCATENATE can be used in Sourcetable today, it isn't clear if CONCATENATE will be available in later versions of Excel.
Can I use the ampersand (&) instead of CONCATENATE?
Yes, the ampersand allows for simple concatenation and may be used in place of the CONCATENATE function. The advantage of using the ampersand is that it is faster and easier than using CONCATENATE.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.