Excel formula help please

[Keka001]

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

 

[#2]

@Keka001 

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.

[#3]

=WEBSERVICE("https://e.anyoupin.cn/eh3/?regreplace~\d+~{1:SHORTANSWER:=\0}~" & encodeurl(A2))

[#4]

@peiyezhu #NAME?

[#5]

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:=")&"}")

[#6]

Your Excel version?office 365 ?Excel 2010?
please screenshot?

[#7]

@peiyezhu office 365

[#8 · Accepted solution]

@Keka001 

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)
))

[#9]

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!

[#10]

https://www.microsoft.com/en-us/microsoft-365/blog/2013/03/21/use-webservice-functions-to-automatica...


I do not know why your Excel not support WEBSERVICE.

[#11]

https://translate.yandex.com/en/?source_lang=en&target_lang=ru&text=webservice

maybe the translation
https://learn.microsoft.com/ru-ru/office/vba/api/excel.worksheetfunction.webservice

[#12]

ENCODEURL КОДИР.URL

Please replace encodeurl with above equivalent Russion.