CJoin

 

Syntax: CJoin(InputRange, ColumnSeparator, RowSeparator, AutoFormat)

 

Equivalent Function Names: N/A

 

Purpose: Function used to concatenate a range of cells into a single cell ("cell join").
 

Parameters: 
 

1.InputRange - Cells to be concatenated - a number of columns and any number of rows
 

2.ColumnSeparator - The separator of the cells in the same row (Optional)
 

3.RowSeparator - The separator of the cells in the same column (Optional)
 

4.AutoFormat - an optional flag signifying if the result should be automatically converted to a range and if the result should be automatically formatted as Excel Data Types
 

 

Examples:

1. Concatenate a number of cells in a number of rows

=CJOIN(A1:D2,", ","|")

 

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017