LibreOffice Calc: How to remove a character from multiple columns
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Puzzle Game 5 Looping
--
Chapters
00:00 Libreoffice Calc: How To Remove A Character From Multiple Columns
00:36 Accepted Answer Score 7
00:53 Answer 2 Score 10
01:23 Answer 3 Score 2
01:33 Answer 4 Score 4
01:43 Thank you
--
Full question
https://superuser.com/questions/387144/l...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#libreofficecalc
#avk47
ANSWER 1
Score 10
If your strings are of unequal length you can use the mid() and len() commands combined.
In your example the command would be:
=MID(A1,2,LEN(A1))
Drag it down as in the answer above.
How does it work?
MID returns a sub-string of a string specified as: MID([string], [start index], [end index]). If the [end index] varies, using LEN(A1) specifies the length of the particular string.
ACCEPTED ANSWER
Score 7
Just use =right(A1,8) and drag it down. Right will always give you the X rightmost characters of the string and given it's consistent in this string, it will be the simplest solution.
ANSWER 3
Score 4
The function you are looking for is the text command, SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence)
ANSWER 4
Score 2
You may try Search For and Replace With (Ctrl+h). In other options check Regular expressions.