I imported a financial report from PayPal. All of the Negative amounts in the "Amount" field use a "-" in front of the value. I want to create a new field that removes the "-" and just lists the value of the Amount field.
If the amount doesn't have the "-" symbol, I just want it to leave the record blank.
I tried using a substitute formula in the new field, but not sure how to get a blank value in the new field if the original amount value does not have a "-" sign.
SUBSTITUTE(Amount, "-", " ")
What would be the best way to do this? Thanks in advance.