0

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?

Improve this question
4
  • 2
    How is the Price column formatted? As a currency? Change the format to a suitable number format.
    – DavidPostill ♦
    Commented Jul 5, 2018 at 11:57
  • @DavidPostill not sure - a noob when it comes to these sortsa things:) how does one check?
    – treyBake
    Commented Jul 5, 2018 at 12:02
  • @DavidPostill I think you were right, found a format cells option -> changed to number -1234.00 and got desired output :) should I add answer or not worth it>?
    – treyBake
    Commented Jul 5, 2018 at 12:08
  • 1
    Feel free to add an answer.
    – DavidPostill ♦
    Commented Jul 5, 2018 at 12:23

1 Answer 1

Reset to default
1

Thanks to @DavidPostill - I didn't even consider the fact the column was formatted as currency (despite using search formatted display string option).

I selected the column and used the Format Cells.. option to set to Number(-1234.00) to get my desired output

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .