Skip to content
REFERENCE

U.SPLIT

Summary

Splits the text value of a cell into a row of cells

Syntax

=U.SPLIT(input, [delimiters], [escape_char], [closure_chars])

Parameters

Parameter Required Description
input Yes The cell (or cells) whose value is to be split
[delimiters] No One or more delimiters used to split the input, along with any optional number of delimiters to skip and/or the maximum number of splits. Delimiters can each be a single character or many characters
[escape_char] No If set then input will not be split on a specified delimiter when that delimiter is preceded by this character. Only single-character escapes are supported. If set to TRUE then the escape character is a backslash ('\')
[closure_chars] No If set then input will not be split on any delimiters that reside between specified closure characters; if only a single character provided then it is both opening and closing of closure. Provide a 2nd cell containing TRUE to have closure chars removed from result, and a 3rd cell to remove them if they exist but were not necessary because a value did not contain a delimiter. No closures are recognized by default.

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.PAD(U.SUBRANGE(U.SPLIT(B4:D211,{"U.","("}),,2))

=U.SPLIT(B6)

=U.SPLIT(B10,",")

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.