PowerUp Description
The pwrCONCATENATE PowerUp function concatenates the text in a range of cells. You can specify an optional delimiter character as well as whether to traverse the range by row or by column.
PowerUp Syntax
pwrCONCATENATE(Range, [Delimiter], [Orientation], [IgnoreEmpty])
The pwrCONCATENATE PowerUp function has the following arguments:
Range – Required. This is the range of cells containing the text to concatenate.
Delimiter – Optional. The delimiter character will be inserted between the concatenated text from individual cells. The default value is an empty string. Or, no delimiter.
Orientation – Optional. The default orientation is by row. Or first across, then down. The allowed values are:
ROWS
COLS
IgnoreEmpty – Optional. The default is to ignore empty cells.
Return Value
pwrCONCATENATE will return the concatenated text string.
Remarks
If a cell in the range is empty, it is skipped.
If the last cells in a range are empty, an extra delimiter character will be appended to the returned string.
Example
=pwrCONCATENATE(A1:C15, "|", "COLS")
This will concatenate the range of cells from A1 to C15. The order of concatenation will be A1, A2, A3, … A15, B1, B2… and a pipe character (“|”) will be inserted between the text of each cell.
