How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?
You can remove the leading single quote (which actually isn't part of the string in the cell) using a regex-based search and replace:
- Search for all characters between the start and end of the string
^.*$ - replace with match
&
From the "Data" menu, choose "Text to columns".