Forum Discussion
Solved
Extract text from Comma Separated Cell to another Comma Separated Cell
Hi Community, I was wondering if anyone could help me with this problem. Any method to achieve "Desired Outcome" column would be appreciated. Data Desired Outcome BAR-Barcelona (1), RM-...
=LET( ζ, TEXTSPLIT(A1, "-", " "), TEXTJOIN(", ", , FILTER(TAKE(ζ, , 1), 1 - ISNA(TAKE(ζ, , -1)))) )
One more variant
=LET(
range, $B$2:$B$5,
MAP(
range,
LAMBDA(v,
LET(
s, TEXTSPLIT(v, {",","-"}),
TEXTJOIN(", ", , CHOOSECOLS(s, SEQUENCE(COLUMNS(s) / 2, , 1, 2)))
)
)
)
)