LinkedIn Post by:
Kris Jaganah
=MAP(A2:A6,LAMBDA(x,LET(a,MID(x,SEQUENCE(LEN(x)),1),CONCAT(FILTER(a,a<>VSTACK("",DROP(a,-1)))))))
LinkedIn Post by:
LinkedIn Post by:
Lorenzo Foti
=LET(s;MID(A2;SEQUENCE(LEN(A2));1);REDUCE("";s;LAMBDA(a;v;IF(RIGHT(a;1)=v;a;a&v))))
LinkedIn post by:
Hussein SATOUR
Thank you Excel BI
=MAP(A2:A6, LAMBDA(a, REDUCE(,MID(a, SEQUENCE(LEN(a)),1),LAMBDA(x,y, x&IF(RIGHT(y)=RIGHT(x),"",y)))))
LinkedIn Post by:
Bo Rydobon
=REDUCE("",SEQUENCE(40),LAMBDA(a,n,LET(v,MID(A2:A6,n,1),a&REPT(v,v<>RIGHT(a)))))
