Differences between revisions 1 and 2
Revision 1 as of 2022-12-29 13:25:28
Size: 438
Comment:
Revision 2 as of 2025-04-08 16:54:02
Size: 424
Comment: Cleanup
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
As of Excel 2016 and Office 365, `CONCATENATE` is deprecated and replaced by `CONCAT`. See details [[Excel/Concat|here]]. The '''`CONCATENATE`''' function concatenates values.
Line 11: Line 11:
== Description ==

As of Excel 2016 and Office 365, this function is ''deprecated'' and replaced by [[Excel/Concat|CONCAT]].

----


Line 13: Line 21:
`CONCATENATE` concatenates a series of 1 or more string values into a singular string value. Try:

Excel Concatenate

The CONCATENATE function concatenates values.


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

Excel/Concatenate (last edited 2025-04-08 16:54:02 by DominicRicottone)