⇤ ← 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.
Contents
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)