تابعنا

Microsoft Tech Community - Latest Blogs - Excel Blog

الأحد، 22 ديسمبر 2024

Today’s function is SUPER_TEXTJOIN. It joins text based on rows or columns.

 

Today’s function is SUPER_TEXTJOIN. It joins text based on rows or columns.


,LAMBDA(delimiter,ignoreEmpty,range,[by_col]=
IF(by_col,
BYCOL(range,LAMBDA(col,TEXTJOIN(delimiter,ignoreEmpty,col))), BYROW(range,LAMBDA(row,TEXTJOIN(delimiter,ignoreEmpty,row)))))



ليست هناك تعليقات:

إرسال تعليق