Learn Excel’s CONCAT and TEXTJOIN to merge fields, build labels, and create readable identifiers for reports.
https://juliet-wiki.win/index.php/Excel_Data_Validation:_Prevent_Bad_Inputs
Learn Excel’s CONCAT and TEXTJOIN to merge fields, build labels, and create readable identifiers for reports.