Excel Comparison
TEXTJOIN vs CONCAT in Excel and Google Sheets
TEXTJOIN skipped or kept a blank: SKU-101,Widget,12.50 vs a doubled comma. CONCAT of two cells worked; CONCAT of the range returned #N/A.
#concatenate
1 tutorial tagged “concatenate”.
1 tutorial tagged “concatenate”.
TEXTJOIN skipped or kept a blank: SKU-101,Widget,12.50 vs a doubled comma. CONCAT of two cells worked; CONCAT of the range returned #N/A.