= Excel Concat =

This function becomes available in Excel 2019 and Office 365. For legacy systems, use `CONCATENATE`. See details [[Excel/Concatenate|here]].

<<TableOfContents>>

----



== Usage ==

`CONCAT` concatenates a series of 1 or more values into a single string value. The values can be string values, arrays of string values, or cell ranges.

{{{
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")
=CONCAT(B2," ", C2)
=CONCAT(A:A)
}}}



=== Order of Cell Ranges ===

Given the following table:

||       ||'''A'''||'''B'''||
||'''1'''||a      ||b      ||
||'''2'''||c      ||d      ||

The formula `=CONCAT(A:A,B:B)` would return `acbd`, while the formula `=CONCAT(A1:B2)` would return `abcd`.



----
CategoryRicottone