I have a "rate" field that comes in in different formats so airtable (and excel) treat it as long text.
In excel I convert it to a number with this formula:
=IFERROR(VALUE(IF(ISNUMBER([@Rate]),[@Rate],LEFT([@Rate],FIND("$",[@Rate])+4))),"")
Because the field can be:
1) A normal number = keep as is
2) Or something like this:
"$ 0.00
Setup Fee $ 995.00" - where I am trying to strip out the spaces and "Set-Up Fee..." language.
Need help with a formula to do this in Airtable if possible. ISNUMBER doesn't exist because the field type is set as text, etc. I'm wondering if I need to use scripting...but that would be a first for me.
Thanks.
