#shorts
The TEXTJOIN function in Office 365 is used to combine text strings from a range of cells or arrays, and separate them with a specified delimiter. The syntax of the function is:
scss
Copy code
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
where:
delimiter: The character or string that will be used as a separator between the text strings. This can be a text string enclosed in double quotes, or a reference to a cell containing a text string.
ignore_empty: A logical value (TRUE or FALSE) that specifies whether empty cells should be ignored. If set to TRUE, the function will skip over any empty cells in the range or array. If set to FALSE, the function will include empty cells as a blank space in the resulting text string.
text1, [text2], ...: The range of cells or arrays containing the text strings to be joined together.
For example, the following formula joins together the contents of cells A1 through A5 using a comma as the delimiter:
php
Copy code
=TEXTJOIN(",",TRUE,A1:A5)
If the contents of the cells were "apple", "banana", "", "orange", and "grape", the resulting text string would be "apple,banana,orange,grape".
Watch video #shorts online without registration, duration hours minute second in high quality. This video was added by user Gyan On Tube 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,468 once and liked it 1.4 thousand people.