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!
- =WEBSERVICE("https://e.anyoupin.cn/eh3/?regreplace~\d+~{1:SHORTANSWER:=\0}~" & encodeurl(A2))
It seems like you're trying to create a formula in Excel, but the provided text "{1:SHORTANSWER:=}" doesn't be a valid Excel formula. The term "SHORTANSWER" does not represent a built-in function or formula in Excel or Google Sheets, so far I know. It seems to be a placeholder or a specific syntax used in a particular context, such as in a template or a form for collecting short answers or responses.
In Excel, you typically use built-in functions like SUM, AVERAGE, VLOOKUP, etc., to perform calculations or manipulate data within cells. Similarly, in Google Sheets, you use functions like SUM, AVERAGE, VLOOKUP, etc., for similar purposes.
If you're referring to a specific feature or function called "SHORTANSWER" in a specific application or context, please provide more details, see in the link please about the details: Welcome to your Excel discussion space!.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- SHORTANSWER This is not a formula, you need to insert numbers there.I have already tried to make a formula, but here are my attempts: =TEXT(A1,“{1:SHORTANSWER:=0}”)
and =ТЕКСТ(A1;"{1:SHORTANSWER:="&ПОДСТАВИТЬ(A1;" ";"} {1:SHORTANSWER:=")&"}")
