You can have up to 252 references or text strings here. If blank cells are referenced in the CONCAT formula, they are ignored in the output unless placed between commas. TEXTJOIN does the same job ...

The Java printf function makes it easier to create informative strings of text without using String concatenation, or relying on non-standard characters that might trigger output errors. The easiest ...