Setting up a formula to skip over non-numeric values

Regular Visitor

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

@amillerECC 

Can you explain what you want your formula to do? Count values, sum values, filter values, ...?

Please provide clear and detailed information.

@amillerECC 

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))))