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...
A formula to call out number value before text value "Wh"
Jackery 300w
"Wh" or "w"
if "w",try REGEXEXTRACT Function
https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57