Reduce & Lambda functions value error

[nmounir]

Hello everyone,

I have a text Nad45er67 where I want to extract the numbers from using reduce and Lambda functions. For some reason, I keep getting a Value Error. I am not sure what I am doing wrong here.
here is the formula I am using
=REDUCE(A2,SEQUENCE(LEN(A2)),LAMBDA(i,a,--CONCAT(IFERROR(--MID(i,a,1),""))))

your help is greatly appreciated

 

[Fluff]

How about

=--(REDUCE("",SEQUENCE(LEN(A2)),LAMBDA(i,a,CONCAT(i,IFERROR(--MID(A2,a,1),"")))))

 

[nmounir]

How about

=--(REDUCE("",SEQUENCE(LEN(A2)),LAMBDA(i,a,CONCAT(i,IFERROR(--MID(A2,a,1),"")))))

Thank you Fluff, it works very well. However, I can't include A3 and A4 to let the formula spill. I am still getting a Value error.

 

[Fluff]

How about

=LAMBDA(txt,--(DROP(REDUCE("",txt,LAMBDA(i,a,VSTACK(i,CONCAT(IFERROR(--MID(a,SEQUENCE(LEN(a)),1),""))))),1)))(A2:A3)

 

[nmounir]

How about

=LAMBDA(txt,--(DROP(REDUCE("",txt,LAMBDA(i,a,VSTACK(i,CONCAT(IFERROR(--MID(a,SEQUENCE(LEN(a)),1),""))))),1)))(A2:A3)

It works perfectly. Thank you very much Fluff.
i am just wondering why my formula never worked? any idea? maybe I am not fully understanding the reduce function very well.

 

[Fluff]

The main problem with your formula is that you were trying to pass an array to sequence which does not work.