For some reason, when I import data from a certain unnamed source (toggl.com), some of the time columns have an apostrophe in them.
When I have this data loaded in Calc, is there a quick, easy way to remove these?
The columns look like:
'12:05:12 '05:05:05 '04:04:44
And I want:
12:05:12 05:05:05 04:04:44
I see the =REPLACE function, but I can't seem to get that to work. Maybe I don't understand the steps.