libreoffice-calc
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.
Try replace _etgn.* with nothing using regular expressions.
Edit Now tested as working - note full stop is required.
Start with a formula in cell B1.
Then click on the small black square in the lower right hand corner of B1 and drag down, for example to B5.
To use the menu instead, select B1 to B5 and go to Sheets -> Fill Cells -> Down.
To quickly apply the formula to the entire column, see https://stackoverflow.com/questions/26868186/quickest-way-to-apply-a-formula-to-an-entire-column.
These are not Array Functions, because they just deal with a single value at a time.
Best Answer
Just use
=right(A1,8)and drag it down. Right will always give you theXrightmost characters of the string and given it's consistent in this string, it will be the simplest solution.