Join

Description of formula:
Connects several text strings together and separates them with separator.
Syntax:
join(separator,texts)
Parameters:
separator
(type: text) text, which separates form each other connected text strings
texts
(type: text or text array) the addresses of cells with texts you want to connect
Returned type:
Text
Examples:
=join('A',B1:B3)
=join(', ',Section1.A)
=join(' ',array(B1,D5))
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk