... 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 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.