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 information. I simply want it to skip over any non-numeric data detected and allow the formula to continue to work. Is there a way to accomplish this? IF or ISNUMBER won't accomplish what I need. Thank you.
2 Replies
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))))Can you explain what you want your formula to do? Count values, sum values, filter values, ...?
Please provide clear and detailed information.
