Forum Discussion
Setting up a formula to skip over non-numeric values
Looking for a solution on a formula that would allow me to skip over non numeric values that might appear in a cell. I don't want to strip this data out of these cells or replace it with other inform...
The goal isn't clear. I'm guessing you want to keep a cell's contents but have a formula read only the numbers in an alphanumeric? If that's the case, this might work.
365 solution:
=LET(str,A1,arr,MID(str,SEQUENCE(LEN(str)),1),REDUCE("",arr,LAMBDA(a,v,IF(ISNUMBER(v*1),a&v,a))))