SOLVED

Copper Contributor

It needs to be done as in the screenshot, I have already tried, but all attempts were unsuccessful and to no avail

11 Replies

# Re: Excel formula help please

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!

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

@peiyezhu #NAME?

# Re: Excel formula help please

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

# Re: Excel formula help please

Your Excel version?office 365 ?Excel 2010?

# Re: Excel formula help please

@peiyezhu office 365

best response confirmed by Keka001 (Copper Contributor)
Solution

# Re: Excel formula help please

Try this Lambda which is designed to handle arrays:

``````'ShortAnswer
=LAMBDA(array,LET(
LET(
split, TEXTSPLIT(each_string, " ", CHAR(10)),
strings, MAP(split, LAMBDA(e, answer & e & "} ")),
CONCAT(strings)
)
),
))``````

# Re: Excel formula help please

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!

# Re: Excel formula help please

ENCODEURL КОДИР.URL

Please replace encodeurl with above equivalent Russion.
1 best response

Accepted Solutions
best response confirmed by Keka001 (Copper Contributor)
Solution

# Re: Excel formula help please

Try this Lambda which is designed to handle arrays:

``````'ShortAnswer
=LAMBDA(array,LET(