= Excel Concat =

The '''`CONCAT`''' function concatenates values.

<<TableOfContents>>

----



== Description ==

This function was added in Excel 2019 and Office 365. For legacy systems, use [[Excel/Concatenate|CONCATENATE]].

----



== Usage ==

Try:

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



=== Order of Ranges ===

Given the below worksheet:

||       ||'''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