Forum Discussion
formula to extract number value before a specific criteria
Hello, I'm trying to extract first batch of numbers from the string below so it'll be 300, can anyone help? A formula to call out number value before text value "Wh" Jackery 300w portable po...
Try the following formula-
=@LET(x,--TEXTSPLIT(SUBSTITUTE(A1,"w ", " "),," "),FILTER(x,ISNUMBER(x)))