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 Lists of Values

Usage

CONCAT concatenates a series of 1 or more values into a single string value. The values can be string values or cell ranges. 

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

Order of Lists of Values

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