Main Page/IT/LibreOffice

From Lewis Consultancy Wiki
< Main Page‎ | IT
Jump to: navigation, search

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
    &