Difference between revisions of "Main Page/IT/LibreOffice"
From Lewis Consultancy Wiki
Jump to navigationJump to search (Created page with "=Remove Text Formatting Quote= Sometimes Libreoffice does bad things when you import CSV files. You can remove a single quote ' at the beginning of text formatted cells using ...") |
(No difference)
|
Latest revision as of 15:26, 9 February 2016
Remove Text Formatting Quote
Sometimes Libreoffice does bad things when you import CSV files. You can remove a single quote ' at the beginning of text formatted cells using find and replace:
- select use regex option in find and replace
- Find for
^.*$
- replace with
&