Letter casing standardisation (UPPER, LOWER, PROPER), string concatenation with & and CONCAT, and delimiter-separated joining with TEXTJOIN.
“6.2 Case Standardization & Joining: UPPER, LOWER, PROPER, CONCAT & TEXTJOIN” is part of Formulas That Do the Work. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
