Excel Concatenate

As of Excel 2016 and Office 365, CONCATENATE is deprecated and replaced by CONCAT. See details here.

Contents

Usage

CONCATENATE concatenates a series of 1 or more string values into a singular string value.

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