Remove ` accent mark from currency cell in Calc

When downloading reports from my broker into Librecalc, the entries in currency cells will contain a hard-coded accent mark and currency symbol (’$1234.56). I want to remove the accent mark and currency symbol from these cells without having to manually edit each one, so that the entries appear as simple numbers (1234.56).

I have attempted to use the Search and Replace function, but it does not seem to be able to find the accent mark, thus is responds with a “not found” error message.

Select the cells, choose menu Data - Text to Columns… - OK.

EDIT: Unmark the Format as Currency button in the toolbar, (or press Ctrl+Shift+4).

LibreOffice Help on Text to Columns.

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.

See also this FAQ.