Excel Concat
This function becomes available in Excel 2019 and Office 365. For legacy systems, use CONCATENATE. See details here.
Contents
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.