Forum Discussion
An UDF for Concatenate Function
Hello I was wondering whether it is possible to achieve this result using VBA/UDF? https://ibb.co/2yn729f Basically what I wanted to do is to be able to concatenate various string fr...
It looks like you have 365. A VBA/UDF solution is superfluous with Lambda as an option:
'Results Lambda
=LAMBDA(words,name,year,LET(word1, TAKE(words, 1), word2, TAKE(words, -1), word1 & " " & name & " " & word2 & " " & year))
