Forum Discussion
excel
=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?
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.