Are there clear limitations when creating formulas to alter text/outputs in with LOOKUP data?
I’ve tried using SUBSTITUTE to replace a “,” in between a LOOKUP output of two first names (e.g. “John, Jane”) with " & " to better format addressing both n...