Forum Discussion
Another issue with Value transformation.
I've played for a couple of days with this, having tried a number of different solutions that worked for others. Cannot figure out how to make a text field convert to value. Here is my XLS. I am runn...
Hi, tea1982!
The issue is that there’s a non-breaking space character (Char 160), which often shows up when copying data from the web. You can remove this character, along with the $ symbol, like this:
=--SUBSTITUTE(SUBSTITUTE(B6,CHAR(160),),"$",)Blessings!