Excel Concatenate

The CONCATENATE function concatenates values.

Contents

Description

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

Try:

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