Differences between revisions 1 and 3 (spanning 2 versions)

Excel Concat

The CONCAT function concatenates values.

Contents

Description

This function was added in Excel 2019 and Office 365. For legacy systems, use CONCATENATE.

Try:

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

Given the below worksheet:

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

-  ⇤ ← Revision 1 as of 2022-12-29 13:33:12 → 
  Size: 765
  Editor: DominicRicottone
  Comment:
+   ← Revision 3 as of 2025-04-08 16:55:27 → ⇥
  Size: 691
  Editor: DominicRicottone
  Comment: Cleanup
-Deletions are marked like this.
+Additions are marked like this.
 Line 3:
-This function becomes available in Excel 2019 and Office 365. For legacy systems, use `CONCATENATE`. See details [[Excel/Concatenate|here]].
+The '''`CONCAT`''' function concatenates values.
 Line 11:
+== Description ==

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

----
-Line 13:
+Line 21:
-`CONCAT` concatenates a series of 1 or more values into a single string value. The values can be string values or cell ranges.
+Try:
-Line 23:
+Line 31:
-=== Order of Lists of Values ===
+=== Order of Ranges ===
-Line 25:
+Line 33:
-Given the following table:
+Given the below worksheet: