Assuming resulting is required, the following 22 results were found.
should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need to be multiplied by 1 to convert to a number but what a palava!
to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look like so that my post-staging phase can be developed as it will know what the data and label fields look...