So I have a Price column and all the values has a £
prefixed. These are formatted string. I tried via the Find & Replace function to replace all of these with nothing, but I can't seem to get it to work.
- Search For is set to
£
- Replace with is set to
EMPTY
Search Formatted display string
is checked
Clicking Replace all, just returns search results and nothing else.
Not sure what I'm doing wrong.
Is it a bug or do I need to write a function to replace the character?