Forum Discussion

Keka001's avatar
Keka001
Copper Contributor
Mar 06, 2024

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  
Excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Mar 06, 2024

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

      

NikolinoDE's avatar
NikolinoDE
Gold Contributor

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.

Keka001's avatar
Keka001
Copper Contributor
Mar 06, 2024
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:=")&"}")

Resources