Forum Discussion

Kando2909's avatar
Kando2909
Copper Contributor
Dec 29, 2022

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?

Formulas and Functions

2 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Dec 30, 2022

    Kando2909 

    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.

     

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Dec 30, 2022
    Post sample data and then show your desired output. Attach a sample file.

Resources