Split

Description of formula:
Splits text into an array of texts. Uses separator or separators for this.
Syntax:
split(text,separator|separators)
or
split(text,separator|separators,[removeEmptyEntries])
Parameters:
text
(type: text) the text you want to split
separator|separators
(type: text) text or texts after which the text has to be split
removeEmptyEntries
(type: logical value)(optional parameter) if this parameter is true, function skips empty entries
Returned type:
Array of texts
Examples:
=split('some text',' ')
=split(A1,',',TRUE)
=split(B2,array('|',' '))
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk