I need to run this formula but need it to ignore the text that is in cell W12.
Formula is =sum(w12*t12)/100
Cell w12 reads as ‘15 kestrel’
So I want to ignore everything but the 15, I have other cells with different text so it has to ignore generic text.
Formula is =sum(w12*t12)/100
Cell w12 reads as ‘15 kestrel’
So I want to ignore everything but the 15, I have other cells with different text so it has to ignore generic text.