Summary
The Excel CONCAT function allows you to supply a range of cells to join, in addition to individual cell references.
Purpose
CONCAT allows you to supply a range of cells to join, in addition to individual cell references.
Syntax
= CONCAT (text 1, text 2,…..)
Example Explanation
In the above mentioned example, we has use CONCAT function in Cell F6 for range B2:B6. CONCAT function ignore blank cells and concatenate all values.
Notes
CONCAT is a new function, available in Office 365 and Excel 2019 users only. CONCAT can accept ranges in addition to individual cells
