Hi,
I have multiple rows where my cells look something like this: "+USD 17,286.24" or "-USD 40,918.66" . I just want to extract the number and I'm using this formula:
=RIGHT(F9,(FIND(" ",F9,1)-1))
which works on every other cell I have except where the format reads like my examples above.
Any...