Dec 29 2022 12:27 PM
=TEXTJOIN("",TRUE,MID(M43,SEQUENCE(,LEN(M43),LEN(M43),-1),1))
If you have this formula for cell in one column. Can you add this column to get a total? If so how?
Dec 29 2022 07:01 PM
Dec 29 2022 11:17 PM
It is possible but not trivial!
= SUM(
MAP(target,
LAMBDA(x,
--CONCAT(MID(x,SEQUENCE(,LEN(x),LEN(x),-1),1))
)
)
)
Naming the Lambda function helps both to shorten the formula and convey its intent.