Forum Discussion

Brass Contributor

Feb 03, 2023

Solved

Join names (TEXTJOIN?) with one-cell 2D spilled formula

Below is a snippet of a list of names that follows some pre-specified criteria: How I got there doesn't really matter, but the fact that I was able to get to this point via a dynamic for...

excel

Formulas and Functions

OliverScheurich
Feb 03, 2023
leolapa
=BYCOL(L57:R58,LAMBDA(col,TEXTJOIN("&",,col)))
You can try this formula.

OliverScheurich

Gold Contributor

Feb 03, 2023

leolapa

=BYCOL(L57:R58,LAMBDA(col,TEXTJOIN("&",,col)))

You can try this formula.

leolapa

Brass Contributor

Feb 06, 2023

BYCOL coming to the rescue indeed OliverScheurich, thanks so much for your help!