- Graphics and Text Skills
- Cases
Combines the text of multiple ranges and/or strings, inserting the specified delimiter between the text values being combined.
Grammar
TEXTJOIN(delimiter, ignore_empty, text1…)
delimiter: Delimiter. A text string, either empty, or one or more characters enclosed in double quotes, or a reference to a valid text string.
If a number is provided, it will be treated as text.
ignore_empty: If TRUE, ignore blank cells.
text1…: 1 to 253 text items to be joined. These text items can be text strings or string arrays, such as cell ranges.
Description
TEXTJOIN returns a #VALUE! error if the resulting string exceeds 32767 characters (the cell limit).
Like (810)
Reward
支付宝扫一扫
支付宝扫一扫
评论列表（196条）
测试