💻 Software
How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?
Fresh5 days ago
Mar 15, 202634189 viewsConfidence Score0%
0%
Problem
I've imported a CSV file having the first column to be date-time values in ISO 8601 format like for the first moment of the year 2012. Then, willing to make LibreOffice to recognize the format (as I was looking forward to plot a diagram), I've selected the column, chosen and entered the custom time…
Error Output
2012-01-01T00:00:00.000Z
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?
Low Risk
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
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix