Excel Concatenate

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

Contents

  1. Excel Concatenate
    1. Usage

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)

CategoryRicottone

Excel/Concatenate (last edited 2022-12-29 13:25:28 by DominicRicottone)