Forum Discussion
Solved
Excel formula help please
It needs to be done as in the screenshot, I have already tried, but all attempts were unsuccessful and to no avail {1:SHORTANSWER:=} Help me please
Try this Lambda which is designed to handle arrays:
'ShortAnswer =LAMBDA(array,LET( AddText, LAMBDA(each_string, LET( answer, "{1:SHORTANSWER:=", split, TEXTSPLIT(each_string, " ", CHAR(10)), strings, MAP(split, LAMBDA(e, answer & e & "} ")), CONCAT(strings) ) ), BYROW(array, AddText) ))
Try this Lambda which is designed to handle arrays:
'ShortAnswer
=LAMBDA(array,LET(
AddText, LAMBDA(each_string,
LET(
answer, "{1:SHORTANSWER:=",
split, TEXTSPLIT(each_string, " ", CHAR(10)),
strings, MAP(split, LAMBDA(e, answer & e & "} ")),
CONCAT(strings)
)
),
BYROW(array, AddText)
))
I think I've figured out what the problem is. The problem is that I have Excel with a Russian translation. He does not perceive functions in English well. For example =ТЕКСТ (tr: =TEXT) works, but already in English =TEXT gives an error
Thank you very much!- ENCODEURL КОДИР.URL
Please replace encodeurl with above equivalent Russion.
