Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2022-12-29 13:33:12 →
Size: 765
Editor: DominicRicottone
Comment:
← Revision 2 as of 2022-12-29 13:47:41 → ⇥
Size: 787
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
`CONCAT` concatenates a series of 1 or more values into a single string value. The values can be string values or cell ranges. `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.
Line 23: Line 23:
=== Order of Lists of Values === === Order of Cell Ranges ===

Excel Concat

This function becomes available in Excel 2019 and Office 365. For legacy systems, use CONCATENATE. See details here.

Contents

  1. Excel Concat
    1. Usage
      1. Order of Cell Ranges

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

Excel/Concat (last edited 2022-12-29 13:47:41 by DominicRicottone)