Excel Concatenate

The CONCATENATE function concatenates values.

Contents

  1. Excel Concatenate
    1. Description
    2. Usage

Description

As of Excel 2016 and Office 365, this function is deprecated and replaced by CONCAT.

Usage

Try: 

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

CategoryRicottone