Excel formula help please

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