I’ve converted an HTML table to ODS but all the numbers and dates have an apostrophe in front of them which only shows when a particular cell is highlighted. Is there a quick method of deleting the apostrophe in a column so that the numbers can be used in calculations?
Select the cells, choose menu
Text to Columns… -
More LibreOffice Help on Text to Columns.
Tested with LibreOffice 184.108.40.206 (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 ( → ) to the left of the answer that solves your question.