- Picture and text skills
- Case
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, 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 arrays of strings, such as cell ranges.
Explanation
■ If the resulting string exceeds 32767 characters (the cell limit), TEXTJOIN returns a #VALUE! error.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-TEXTJOIN-han-shu-geng-qiang-da-de-he-bing-wen-ben-han-shu.html
评论列表(196条)
测试