Excel textjoin invalid name error

Describes the cause and action for error messages.

Error Message(English)：
textjoin invalid name error

Resolution

How to correct a #NAME? error - Office Support
https://support.office.com/en-ie/article/how-to-correct-a-name-error-b6d54e31-a743-4d7d-9b61-40002a7・・・

#NAME? エラーの修正方法 - Office サポート - Office Support - Office 365
https://support.office.com/ja-jp/article/-name-%E3%82%A8%E3%83%A9%E3%83%BC%E3%81%AE%E4%BF%AE%E6%AD%A・・・

エクセル エラー #REF! の意味と修正方法 - Tipsfound
https://www.tipsfound.com/excel/01506

EXCEL 2016で新しいIFS関数を使う、#NAME?エラーが出てで使えません ...
https://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q13162595763?__ysp=RXhjZWwgInRleHRqb2luIGlu・・・

The Excel #NAME? Error ? - Blue Pecan Computer Training
https://www.bluepecantraining.com/portfolio/the-excel-name-error/

エクセルのエラー値に強くなろう - Excel塾
https://kokodane.com/kihon15_2.htm

Excel関数一覧表 - FC2
http://yumeclubfujisawa.web.fc2.com/main/bukai/yumepc/ictkouza/excelkouza/excel-kansu.htm

How to Combine and Separate First and Last Name in Excel
https://www.excelcse.com/combine-separate-first-last-name-excel/

Textjoin with if(and) function - Stack Overflow
https://stackoverflow.com/questions/49984850/textjoin-with-ifand-function