For some reason, an export of dates from a source (I think it was CSV export of a calendar from Evolution) gives me an apostrophe followed by a space before the actual dates.
I cannot figure out how to remove those two first characters from all the cells in that column. For some reason, I have absolutely no success using “search and replace”.
I feel like it has to do with how the apostrophe is interpreted by Calc: it shows in the input line, but not when formatted in the cell (whereas the space actually does show). Looking for the character in “search and replace”, be it in “value” or “formula”, returns no result. Bug or feature?
See attached sample file to test. (Edit: it seems the attachment thingy does not work, here is the file: https://cloud.indie.host/index.php/s/4sl2Y9IjunaOLKi)
Using version 184.108.40.206