Excel Concat
The CONCAT function concatenates values.
Contents
Description
This function was added in Excel 2019 and Office 365. For legacy systems, use 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.