FG

LibreOffice Calc: How to remove a character from multiple columns

Fresh3 days ago
Mar 15, 202646585 views
Confidence Score0%
0%

Problem

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: And I want: I see the =REPLACE function, but I can't seem to g…

Error Output

'12:05:12
'05:05:05
'04:04:44

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: LibreOffice Calc: How to remove a character from multiple columns

Low Risk

If your strings are of unequal length you can use the and commands combined. In your example the command would be: Drag it down as in the answer above. How does it work? returns a sub-string of a string specified as: . If the varies, using specifies…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment