Skip to content
REFERENCE

U.CONCAT

Summary

Concatenates the values of multiple cells in a row into a single string

Syntax

=U.CONCAT(substrings, [delimiter], [ignore_blanks], [row_by_row], [escape_delimiter])

Parameters

Parameter Required Description
substrings Yes The row of cells whose values will be concatenated
[delimiter] No The delimiter to be placed between values. Can be a single character or many characters. By default no delimiter is used
[ignore_blanks] No If set to TRUE then cells containing blanks are ignored. Only meaningful if a delimiter is specified
[row_by_row] No If set to TRUE then each row is concatenated independently and a concatenation is returned for each input row By default all cells in a matrix are concatenated together
[escape_delimiter] No If set to TRUE then any cell values that match delimiter are escaped with a backslash ('\'). Only meaningful if a delimiter is specified. By default values matching a specified delimiter are not escaped

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.FORMAT_STRING("config(match={0})",U.CONCAT(U.CONCAT(B145:C146,":",,TRUE),"|"))

=U.CONCAT(U.CONCAT(P256:Q258,":",FALSE,TRUE,FALSE),"|",TRUE,FALSE,FALSE)

=U.CONCAT(B7:D7)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.